Postgres Pro
Downloads
Home   >   mailing lists

Row count mismatch post pg_dump piped restore - Mailing list pgsql-bugs

From chandrakant sharma
Subject Row count mismatch post pg_dump piped restore
Date
Msg-id CALBC4UuFkUeaBvJaP6gfBXA3zP_LfaD76qfLFgp_YYogKQ2sDA@mail.gmail.com
Whole thread Raw
Responses Re: Row count mismatch post pg_dump piped restore
List pgsql-bugs
Tree view 
Hello Team,

I tried using the following command line argument to restore a table on the
fly using pg_dump. The source and target dbs are GP. The process completed
successfully however, the number of rows in the target were higher than as
compared to source. The difference was greater the 1K  rows.

Here is the command line used:
pg_dump -a -x -U remote_user -h remote_server -t table_to_copy source_db |
psql target_db

Version of pg_dump being used:
pg_dump (PostgreSQL) 8.4.20


--
Thanks and Regards
Chandrakant Sharma

pgsql-bugs by date:

Previous
From: pravin@gida.in
Date:
Subject: BUG #13961: Unexpected behaviour of JSONB_SET if the new_value is null
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #13938: CAST error on Index "function must be immutable"