Postgres Pro
Downloads
Home   >   mailing lists

Re: I have no idea why pg_dump isn't dumping all of my data - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: I have no idea why pg_dump isn't dumping all of my data
Date
Msg-id CAM+6J94+9YLc+hd_qbr+M0TZROP6wa2S_dSNpps-KrJyo--g-g@mail.gmail.com
Whole thread Raw
In response to I have no idea why pg_dump isn't dumping all of my data  (Simon Connah <simon.n.connah@protonmail.com>)
Responses Re: I have no idea why pg_dump isn't dumping all of my data
List pgsql-general
Tree view
Can you try dumping using verbose flag.
-v

Just want to confirm if the user has relevant permissions.


On Fri, May 21, 2021, 3:04 PM Simon Connah <simon.n.connah@protonmail.com> wrote:
Hi,

I'm running the following command to dump my database:

/usr/bin/pg_dump --file=/home/simon/nanoscopic_db_127_0_0_1-2021_05_21_10_25_28-dump.sql --dbname=nanoscopic_db --clean --create --if-exists --username=nanoscopic_db_user --host=127.0.0.1 --port=5432

and yet when I run that all I get in the SQL file is the following:

https://gist.github.com/simonconnah/e1a15b1536b6e519b84481ae74f082bf

I'm at a total loss. I've tried all the relevant looking command line switches and nothing seems to dump the actual contents of the database. It just dumps the extension command. Can anyone help me to figure this out please? It is probably something stupid that I am doing wrong.

Simon.

pgsql-general by date:

Previous
From: Simon Connah
Date:
Subject: I have no idea why pg_dump isn't dumping all of my data
Next
From: Simon Connah
Date:
Subject: Re: I have no idea why pg_dump isn't dumping all of my data