Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-25 Thread Simon Connah
‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 12:46, Ian Lawrence Barwick wrote: > 2021年5月21日(金) 20:42 Vijaykumar Jain vijaykumarjain.git...@gmail.com: > > > PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an > > Extension > > > > so it works as expecte

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Ian Lawrence Barwick
2021年5月21日(金) 20:42 Vijaykumar Jain : > > PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an > Extension > > so it works as expected. > someone would have to point to the reference wrt modification of data in > objects created via extension. If you want to be able to dump da

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Vijaykumar Jain
PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an Extension so it works as expected. someone would have to point to the reference wrt modification of data in objects created via extension. The main advantage of usin

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Vijaykumar Jain
so this is the summary. I modified the extension to have a simple sql that created table and inserted a value. *** postgres@go:~$ cat /opt/postgresql-13/local/share/extension/nanoscopic--1.0.sql create table foo(id int); insert into foo values (1);

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Vijaykumar Jain
ok, I think this is what it is. I copied the files to the extensions folder. ls /opt/postgresql-13/local/share/extension/nanoscopic* /opt/postgresql-13/local/share/extension/nanoscopic--1.0.sql /opt/postgresql-13/local/share/extension/nanoscopic.control and loaded the extensions. the relations

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Simon Connah
This is the source code of the extension in question: https://github.com/xmrsoftware/nanoscopic/tree/master/sql/nanoscopic ‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 11:29, Vijaykumar Jain wrote: > i just did a dump of a db which was owned by postgres but some tables owned >

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Vijaykumar Jain
i just did a dump of a db which was owned by postgres but some tables owned by other users and it ran fine. I am not sure of that nanoscopic extension though. *** createdb -e foobar; postgres=# \c foobar You are now connected to database "foobar" as user "postgres".

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Simon Connah
‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 10:55, Vijaykumar Jain wrote: > 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 > wrote: > > > Hi, > > > > I'm runnin

Re: I have no idea why pg_dump isn't dumping all of my data

2021-05-21 Thread Vijaykumar Jain
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 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_