‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, May 21st, 2021 at 10:55, Vijaykumar Jain <vijaykumarjain.git...@gmail.com> 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 <simon.n.con...@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. pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined access methods pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading transforms pg_dump: reading table inheritance information pg_dump: reading event triggers pg_dump: finding extension tables pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding the columns and types of table "public.blog_user" pg_dump: finding default expressions of table "public.blog_user" pg_dump: finding check constraints for table "public.blog_user" pg_dump: finding the columns and types of table "public.blog" pg_dump: finding default expressions of table "public.blog" pg_dump: finding the columns and types of table "public.blog_post" pg_dump: finding default expressions of table "public.blog_post" pg_dump: finding check constraints for table "public.blog_post" pg_dump: finding the columns and types of table "public.blog_post_comment" pg_dump: finding default expressions of table "public.blog_post_comment" pg_dump: finding the columns and types of table "public.blog_page" pg_dump: finding default expressions of table "public.blog_page" pg_dump: finding the columns and types of table "public.blog_user_permissions" pg_dump: finding default expressions of table "public.blog_user_permissions" pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading indexes for table "public.blog_user" pg_dump: reading indexes for table "public.blog" pg_dump: reading indexes for table "public.blog_post" pg_dump: reading indexes for table "public.blog_post_comment" pg_dump: reading indexes for table "public.blog_page" pg_dump: reading indexes for table "public.blog_user_permissions" pg_dump: flagging indexes in partitioned tables pg_dump: reading extended statistics pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading rewrite rules pg_dump: reading policies pg_dump: reading row security enabled for table "public.blog_user_blog_user_id_seq" pg_dump: reading policies for table "public.blog_user_blog_user_id_seq" pg_dump: reading row security enabled for table "public.blog_user" pg_dump: reading policies for table "public.blog_user" pg_dump: reading row security enabled for table "public.blog_blog_id_seq" pg_dump: reading policies for table "public.blog_blog_id_seq" pg_dump: reading row security enabled for table "public.blog" pg_dump: reading policies for table "public.blog" pg_dump: reading row security enabled for table "public.blog_post_blog_post_id_seq" pg_dump: reading policies for table "public.blog_post_blog_post_id_seq" pg_dump: reading row security enabled for table "public.blog_post" pg_dump: reading policies for table "public.blog_post" pg_dump: reading row security enabled for table "public.blog_post_comment_blog_post_comment_id_seq" pg_dump: reading policies for table "public.blog_post_comment_blog_post_comment_id_seq" pg_dump: reading row security enabled for table "public.blog_post_comment" pg_dump: reading policies for table "public.blog_post_comment" pg_dump: reading row security enabled for table "public.blog_page_blog_page_id_seq" pg_dump: reading policies for table "public.blog_page_blog_page_id_seq" pg_dump: reading row security enabled for table "public.blog_page" pg_dump: reading policies for table "public.blog_page" pg_dump: reading row security enabled for table "public.blog_user_permissions_blog_user_permissions_id_seq" pg_dump: reading policies for table "public.blog_user_permissions_blog_user_permissions_id_seq" pg_dump: reading row security enabled for table "public.blog_user_permissions" pg_dump: reading policies for table "public.blog_user_permissions" pg_dump: reading publications pg_dump: reading publication membership pg_dump: reading subscriptions pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving search_path = pg_dump: saving database definition pg_dump: dropping DATABASE nanoscopic_db pg_dump: creating DATABASE "nanoscopic_db" pg_dump: connecting to new database "nanoscopic_db" pg_dump: creating EXTENSION "nanoscopic" pg_dump: creating COMMENT "EXTENSION nanoscopic" pg_dump: creating ACL "DATABASE nanoscopic_db"
signature.asc
Description: OpenPGP digital signature
