Empty table after pg_restore

1 vote

2 answers

2268 views

postgresql postgresql-10 pg-restore unlogged-tables

                          I have a backup of an unlogged table called potential_users, the relation has 58677237 records in it.

Steps:

 pg_dump --format custom --verbose --file "potential_users.backup" --table "public.potential_users" productiondb

    pg_restore -a -t potential_users potential_users.backup

I see the data prompted in the terminal and when it finishes shows:

    PostgreSQL database dump complete

But after a SELECT count(*) FROM potential_users; 0 is returned.

Asked by Imanol Y. (785 rep)

Mar 12, 2018, 11:42 AM
Last activity: Dec 3, 2022, 01:07 AM

Empty table after pg_restore

Related Questions