I currently have created a database via Supabase, which uses the Postgres database. After doing so, I then downloaded Postgres on my computer, which gave me the psql command line script for use to ...

My codebase and database is hosted on different servers with Ubuntu 12.04. database => web1 codebase => web2 I am trying to take my database backup (web1) through the application(web2). ...

I am using pg_dump and pg_restore for backup and restore of postgres database. Here is some information from documentation that will be relevant for this question For Pg_restore, -C option is des...

I'm working on the project where we are using :sql schema format for the Active Record dumper (to support more complex logic like triggers). We have a lot of views and I can see in the database/s...

I need to specify sslmode=allow when using psql to connect to my PostgreSQL DB, like: psql sslmode=allow -h localhost -p 5432 otherwise I get server does not support SSL, but SSL was required I tr...

We have setup database postgresql 11 on a system. There are about 8 tables. From few days, we are facing this problem ERROR: invalid page in block 9698 of relation base/16385/16560 SQL state: XX00...

I want to take a pg_dump of my data from HasuraDB to my local machine. What is the recommended way to do this ?

I try to do a table data dump using pg_dump, something like this: pg96\bin\pg_dump ... --format plain --section data --column-inserts --file obj.account.backup --table obj.account database_xyz I...

The Problem I use pg_dump to create a schema-only archive file of our database. I'd like to reduce the size of this file (and decrease the restore time) by omitting all but one of a set of partitio...

I've recently started developing apps with PostgreSQL as backend DB (imposed on me) with no previous experience of Postgres. So far it hasn't been too bad, but now I run into a problem to which I c...

i used below command to backup my database sudo -u user_name pg_dump dbName -f /home ..../someWhere/db.sql but it gives me this : pg_dump: [archiver] could not open output file "/home ..../some...

i was using the following syntax for pg_dump and restore pg_dump eval --inserts -b -c --encoding UTF8 -Fc -f eval.sql.tar.gz -x -U postgres createdb -T template0 test -U postgres pg_restore -d tes...

I have two host servers s1 and s2. In both the servers I have a schema named n1. Now I have made some changes to some of the tables present in schema n1 of s1. I want the same change to be done to ...

Working with Postgres 12 / Windows 10. Trying to copy a remote database to localhost with the following command: pg_dump -C -h remotehost -p 5432 -U postgres remotedb | psql -h localhost -p 5432 -U...

pg_dump --table=export_view --data-only --column-inserts mydb > export_view.sql pg_dump (PostgreSQL) 10.7 (Ubuntu 10.7-1.pgdg18.04+1) Export specific rows from a PostgreSQL table as INSERT SQL...

I have a database with some tables for the application settings, lists like users, departments, cities. I want the structure and the data for those tables. So if i get a new user the backup will sa...

My network looks like this: App (many connections) pg_bouncer (few sessions) PostgreSql nodes ----------------------- nodes ----------------- nodes So pg_bouncer multiplexes connections giving app...

I have tried to install pg_dump as part of installation of postgres-client, however it does not include pg_dump. Can pg_dump be installed without a full installation of postgres on Alpine Linux?

I run a daily backup of my database using pg_dump and pg_restore that recently stopped working after I pushed an update. I have a function validate_id that's a Case/When statement just as a quick c...

I'm beginner with PostgreSQL and doing backups using: sudo -u postgres pg_dumpall > /~/postgreBackup.SQL Works fine! Now I want to backup a single table "TableName" in a scheme "S...

I am taking the dump of postgres database using "pg_dump database_name > backup.sql". Later on I am doing some modifications in the original database(database_name) and then I am restoring the data...

I get the following error while restoring database from dump file on server: ERROR: relation "table_id_seq" does not exist LINE 1: SELECT pg_catalog.setval('table_id_seq', 362, true); my loc...

Getting problem when taking backup on database contains around 50 schema with each schema having around 100 tables. pg_dump throwing below error suggesting that to increase max_locks_per_transacti...

I would like to know the locks that the COPY method may require. When I run it, I see that it uses the lock SHARE ACCESS, I would like to know if it is the only one. I also would like to know the ...

I have a client made a backup using pg_dump and its size is almost 700GB while the pg_database_size is just about 195GB. I already did run the VACUUM FULL but the result still the same. How could ...