Hi,
We have successfully implemented a Backup and Recovery process in our
organization and currently testing it out. We took a previous day backup and
tried to restore it to a point in time.
The database is able to start applying the recovery settings. But it
recovered records past the recovery
I have a master slave setup that is on the most part working smoothly. The logs
are getting
shipped to the slave, the slave is requesting them and then applying them.
The problem is that the logs are building up in the pg_xlog dir and not
overwriting. I do have
archive_mode on in postgresql.conf
Hi Guys,
I tried to setup kerberos authentication with postgresql 8.4.7 on Ubuntu 10.10.
When I use:
$ psql –h ubuntu.server –U gavin dbname
I get following error:
psql: Kerberos 5 authentication not supported.
And from the server side of postgresql, I could see following log:
2011-03-23 09:1
Hi Raghu and thanks!,
This fix helped me too.
My installation is an OpenSCG PostgreSQL 9.0.3 build with PostGIS 1.5.2
installed; and as per Sandra - the installation worked fine for several days
then failed - I got mine going again the first time by multiple restarts and
some port config changes, b
Hello Brad,
Thank you for this information.
We have database tables that are around 50-100 GB each (table). While
processing such tables, it seems to be crucial that the table fits into memory
(especially if the database table is not on a SSD drive).
Until now we have thought "shared_buffers"
We are using pg_standby to consume WAL files from another postgres
server. Both servers are running 8.4 on ubuntu lucid. One of the WAL
files had incorrect permissions:
running restore :cp: cannot open `/some/path/
000100E70081' for reading: Permission denied
It looks like pg_
On Mar 19, 2011, at 2:55 AM, John P Weatherman wrote:
> I have recently upgraded to Postgres9 and am building a hot standby for
> reporting. Unfortunately, my end users are providing requirements for
> 1) real time data replication (which the hot standby does) and 2) the
> ability to create temp
