btraut Comments - Answer Overflow

For future readers: I had to install pg_restore 16.x on my machine (I used homebrew's postgresql@16) and restore to another railway postgresql instance. I was never able to restore to a local db.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Update here: it took quite a while on my current internet connection, but I was able to successfully restore the backup using your method!

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Much appreciated!

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Yup. Running now.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

I've been trying so many combinations of pg_restore versions and attempts to install timescale that I'm not 100% sure if I've done this test yet.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

I'm trying this right now. I'm getting pages and pages of this vomit, but maybe it'll work anyway?

pg_restore: error: could not execute query: ERROR:  schema "_timescaledb_cache" does not exist
Command was: COPY _timescaledb_cache.cache_inval_bgw_job  FROM stdin;
pg_restore: error: could not execute query: ERROR:  schema "_timescaledb_cache" does not exist
Command was: COPY _timescaledb_cache.cache_inval_extension  FROM stdin;
pg_restore: error: could not execute query: ERROR:  schema "_timescaledb_cache" does not exist
Command was: COPY _timescaledb_cache.cache_inval_hypertable  FROM stdin;

pg_restore: error: could not execute query: ERROR:  schema "_timescaledb_cache" does not exist
Command was: COPY _timescaledb_cache.cache_inval_bgw_job  FROM stdin;
pg_restore: error: could not execute query: ERROR:  schema "_timescaledb_cache" does not exist
Command was: COPY _timescaledb_cache.cache_inval_extension  FROM stdin;
pg_restore: error: could not execute query: ERROR:  schema "_timescaledb_cache" does not exist
Command was: COPY _timescaledb_cache.cache_inval_hypertable  FROM stdin;

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

This doesn't actually seem to work through the issues that I'm facing. What version of pg_restore are you using, and are you restoring to another database hosted on Railway?

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Gotchya gotchya.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Is that a Railway thing? @cstoneham is the account creator, and I'm pretty sure it's a pro account. I'm his cofounder and an Owner on the account.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

pg_restore -d "postgresql://username:password@localhost:5432/postgres" -F t backup-2024-03-13T06-45-00-104Z.tar

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

10gb 😬

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

tbh, I don't even know what timescale is. We use a pretty barebones postgres setup.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Hmm. But I end up with 0 records. The schema is restored, but no rows.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

To my knowledge, not at all. But it seems all of our pg_dumps have the timescale context baked into them.

55 replies

RRailway

•Created by cstoneham on 3/19/2024 in #✋｜help

Restoring the pg_dump from the postgres-s3-backups tool

Depends on which. 🙂 With homebrew 15, it's 15.x and it was giving me an error about incompatible headers. When I installed homebrew's postgresql@16, I think it was pg_restore 16.2, but it might've been different. The timescaledb docker image has pg_restore 16.2.

55 replies

Gaming

Programming