The only way I know of doing this is to restore the backup to a separate
database or table and doing a "SELECT INTO" statement. The only caveat is that
you need to make sure you delete the outdated records from the prod table. To
do this you may have to temporarily disable foreign key enforcing.
Hi,
I m trying to take backup of data of a particular table using pg_dump.
I used double quotes for table name but output is :
pg_dump : no tables were found.
Command used :
-h localhost -p 5432 -U postgres -W -F p -a -t '"TestTable"' -f
DbBackup/BackupTableActions.sql TestDataBase
This problem
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka wrote:
> Hi,
>
> I m trying to take backup of data of a particular table using pg_dump.
> I used double quotes for table name but output is :
> pg_dump : no tables were found.
>
> Command used :
> -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTa
Hi,
it appeares I've got gaps in the log files.
It's a PG 9.1 from the OpenSuse 12.1 distribution.
I know the server is running so it should dump it's feelings all the
time in those files in PGDATA/pg_log.
But I find huge gaps where nothing is written.
E.g. yesterday the last entry is at 09.5
Andreas writes:
> it appeares I've got gaps in the log files.
> It's a PG 9.1 from the OpenSuse 12.1 distribution.
> I know the server is running so it should dump it's feelings all the
> time in those files in PGDATA/pg_log.
> But I find huge gaps where nothing is written.
The only suggestion
PostgreSQL 9.1.3
I just moved our test database from PostgreSQL 9.0 to 9.1. I also changed my
log settings. I am seeing every single SQL statement that PostgreSQL performs
by my Java applications. Is there some way to only display the details when
there is an error? I would assume yes. Bu
"Campbell, Lance" writes:
> PostgreSQL 9.1.3
>
> I just moved our test database from PostgreSQL 9.0 to 9.1. I also
> changed my log settings. I am seeing every single SQL statement
> that PostgreSQL performs by my Java applications. Is there some way
> to only display the details when there is
Am 06.03.2012 18:38, schrieb Tom Lane:
Andreas writes:
it appeares I've got gaps in the log files.
It's a PG 9.1 from the OpenSuse 12.1 distribution.
I know the server is running so it should dump it's feelings all the
time in those files in PGDATA/pg_log.
But I find huge gaps where nothing is
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I left them on defaults.
> Actually they are even commented out.
Never assume that the commented out version == default == actual value.
Always explicitly set parameters you care about.
- --
Greg Sabino Mullane g...@turnstep.com
End Point
