Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
Not really a solution but a workaround that worked is to restore through a csv file.
COPY potential_users FROM '/potential_users.csv' WITH (FORMAT csv);
Don't you need to tall pg_restore which database to populate?
pg_restore -a -t potential_users potential_users.backup -d OTHER_DATABASE
From the Docs:
If a database name is specified, pg_restore connects to that database and restores archive contents directly into the database. Otherwise, a script containing the SQL commands necessary to rebuild the database is created and written to a file or standard output.
It sounds like you're seeing the latter, with the data (SQL script) appearing in the window.
