pg-dump Archives

In Postgresql, after pg_dump the access privileges on the database itself are not restored

By adminPosted on January 31, 2023

Question : Suppose user foo owns a database gee, and user foo has granted user bar with all access privileges […]

By adminPosted on January 28, 2023

Question : Postgres 11, Windows 10, pgAdmin 4 I have a large post-gis enabled table (29million rows, 20GB + a […]

By adminPosted on January 18, 2023

Question : When I’m using custom format (-Fc) in pg_dump, the file is smaller (42kb), and when I restore it, […]

By adminPosted on January 8, 2023

Question : I am trying to restore a binary pg_dump backup under a different database name that was in the […]

By adminPosted on January 6, 2023

Question : I have a SQL dump file: C:UsersRayyanDesktopdump_2.sql. I have been trying to import this for so long. I […]

By adminPosted on December 22, 2022

Question : I am looking for a way to dump PostgreSQL12 database model into a directory/file structure, instead of a […]

By adminPosted on December 21, 2022

Question : I had this error after the execution of pg_restore: pg_restore: finished item 19181 MATERIALIZED VIEW DATA avenant_f pg_restore: […]

By adminPosted on December 16, 2022

Question : I was hoping I could get a clear answer on how to ensure taking a full Postgres backup […]

By adminPosted on December 9, 2022

Question : Well say I have two physically separate database and I wish to replace database B with data from […]

By adminPosted on December 9, 2022

Question : I am trying to dump this data into Postgres: COPY address_types (game_id, device_type) FROM stdin; 1 Ps3 2 […]