From: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | I have no idea why pg_dump isn't dumping all of my data |
Date: | 2021-05-21 09:33:53 |
Message-ID: | H-_GDPMU33gqao15xoD_alzsugNZBpqB7xqECQmr3Yj19kE4BVzFdmbUimnqqfLz0iyBn6WmOVFB5gwV9Zu--mtBDu_214c0UUFbirryD94=@protonmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Vijaykumar Jain | 2021-05-21 09:55:40 | Re: I have no idea why pg_dump isn't dumping all of my data |
Previous Message | Franck Routier (perso) | 2021-05-21 07:37:18 | Re: Any insights on Qlik Sense using CURSOR ? |