Torsten Luettgert <[EMAIL PROTECTED]> writes:
> Now, this works fine about 50% of the time, but on some machines, the
> reindexdb dies from a SIGPIPE signal. The logs look like this:
> Aug 3 04:08:10 prospero postgres[27101]: [1-1] NOTICE: table
> "pg_class" was reindexed
> Aug 3 04:08:11 prosp
Hello,
During our backup, we are using pg_dump (sql format if no LO) and then
gzip to compress the sql file.
I read that the "custom" format can also compress ( -Z option) the dump.
Does someone use the latest to dump/compress backups ? Could it be a
good way to speed up the backup ?
Regards
Dear Friends,
I want to know if I open a table to view the data a new connection is
opened. If I open another table/execute a query does a another new
connection is opened? As per manual, I know that for a database cluster and
the same port a postgresql instance runs. But if we run multiple SQL
sta
Hello all,
we're using PostgreSQL 8.2.5 with some 300 databases under CentOS 4.6.
To reduce on-disk size of our DBs, we're doing the following after
the nightly dumps:
reindexdb dbname
vacuumdb -f -z dbname
Now, this works fine about 50% of the time, but on some machines, the
reindexdb dies from
Amit jain wrote:
Dear All,
I am having a backup file in tar format. While restoring it through
pg_restore instantly i am getting an following error.
*Command - pg_restore -d cipa
/cipa/RAJASTHAN/RAJASTHAN/CIPABACKUP01_08_2008.TAR
Error - pg_restore: [archiver] out of memory
*I have increa
Dear All,
I am having a backup file in tar format. While restoring it through
pg_restore instantly i am getting an following error.
*Command - pg_restore -d cipa
/cipa/RAJASTHAN/RAJASTHAN/CIPABACKUP01_08_2008.TAR
Error - pg_restore: [archiver] out of memory
*I have increased shmmax , maintenace
Dear Support!
I speak English not well, sorry.
I use Postgresql 8.3.0 on Win32. So, when I try to restore into database, I
have an error such as
"2008-08-05 12:07:33 MSD ERROR: could not load library "C:/Program
Files/PostgreSQL/8.3/lib/pldbgapi.dll": unknown error 126
2008-08-05 12:07:33 MSD
