FYI in case you still have the problem after using pg_dump from 8.1 (we did)
you may have an encoding mismatch between your 7.3 and 8.1 databases. Our
7.x database was SQL_ASCII while 8.1 defaults to creating databases as
UTF-8. I had similar "invalid UTF-8 byte sequence" errors. I fixed it by
usin
Title: Getting "cannot remove lock from HTAB" during VACUUM FULL
All,
During our weekly VACUUM FULL we get a "ERROR: cannot remove lock from HTAB" message and then the database appears to hang completely. Other processes can connect to the database, but all queries hang. We must stop the dat
Hello,
A few minutes ago, we were surprised to find a second postmaster process
running on our database machine as a child of the original postmaster. The
child postmaster was around for about a minute then disappeared. This is a
Opteron machine running RedHat AS4 with Postgres 8.1.2.
Does the po
time snapshot of the postmaster
fork()'ing to handle these connections, but because they were rejected, it
never had time to rename itself to 'postgres'?
Stuart
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 10:09 PM
To: Michael Fu
All,
After searching the mailing list archives, Deja's
comp.databases.postgresql.* archives, the Postgres docs, and Google I cannot
find an answer to a strange error I am seeing, so I seek your wisdom.
I am running Postgresql 7.1.1 compiled with GCC 2.95.2 on a Sun 220
Solaris 2.8 box and
> -Original Message-
> From: Larry Rosenman [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 21, 2001 12:19 PM
> To: Tom Lane
> Cc: Stock, Stuart H.; '[EMAIL PROTECTED]'
> Subject: Re: [GENERAL] Error: cannot write block XX of X/X
> blind: re
