Re: [GENERAL] Disk full and WALs

2010-08-01 Thread John Krasnay
On 10-08-01 03:03 PM, Tom Lane wrote: The archiver will retry, *if the archive command returns non-zero exit status*. It sounds to me like you're using an archive command script that dutifully logs a failure but is careless about returning the proper exit status. That was my first thought, too

Re: [GENERAL] Libpq on iPad?

2010-08-01 Thread Sim Zacks
> I would have thought that only backend apps would talk to pgsql? > > Maybe there is a case to allow an ipad app to talk directly to a pgsql > database? Admin work? > Postgresql is the backend. An iPad app that uses the database, needs libpq. If you wanted to scratch the left side of your head wi

Re: [GENERAL] Pglesslog issue

2010-08-01 Thread Koichi Suzuki
Hi, pglesslog needs makefile, header files and .o files of PostgreSQL itself. To build pglesslog, you need PostgreSQL source code as well.Please unpack the source at "contrib" directory of PostgreSQL 8.3 source. Run ./configure and make for PostgreSQL 8.3 first (I hope you already did them) a

Re: [GENERAL] PostgreSQL and distributed transactions

2010-08-01 Thread Jayadevan M
Hello, > > > > See about 2 Phase Commit, but you will need a transaction manager I guess : > > > > http://www.postgresql.org/docs/current/static/sql-prepare-transaction.html > > > > If I may be allowed to toot my own horn, may I suggest this as an example: > http://blog.endpoint.com/2010

Re: [GENERAL] Libpq on iPad?

2010-08-01 Thread Jerry LeVan
On Aug 1, 2010, at 8:00 PM, ABPNI wrote: > > > On 2 Aug 2010, at 00:44, Jerry LeVan wrote: > >> Has anyone looked at the feasibility of building libpq as a first step >> towards building >> An iPad app that can talk to postgresql dbs ? >> >> Thanks >> >> Jerry >> >> Trapped in Steve Jobs

Re: [GENERAL] Libpq on iPad?

2010-08-01 Thread ABPNI
On 2 Aug 2010, at 00:44, Jerry LeVan wrote: Has anyone looked at the feasibility of building libpq as a first step towards building An iPad app that can talk to postgresql dbs ? Thanks Jerry Trapped in Steve Jobs Reality Distortion Field -- Sent via pgsql-general mailing list (pgsql-gene

[GENERAL] Libpq on iPad?

2010-08-01 Thread Jerry LeVan
Has anyone looked at the feasibility of building libpq as a first step towards building An iPad app that can talk to postgresql dbs ? Thanks Jerry Trapped in Steve Jobs Reality Distortion Field -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

[GENERAL] Compression on SSL links?

2010-08-01 Thread Karl Denninger
I may be blind - I don't see a way to enable this. OpenSSL "kinda" supports this - does Postgres' SSL connectivity allow it to be supported/enabled? - Karl <> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [GENERAL] Disk full and WALs

2010-08-01 Thread Tom Lane
John Krasnay writes: > We decided to do a point-in-time recovery, but that failed too, since > the archived WAL file 000102BD0072 was zero-length. Looking > at the logs, the archive command for this file failed at about 6:29am, > but the server continued on until later in the evenin

[GENERAL] Disk full and WALs

2010-08-01 Thread John Krasnay
Hi folks, I recently ran into an issue with PostgreSQL 8.3 on a disk that became full. We freed up some space and restarted PostgreSQL, but startup failed with the following error: 2010-08-01 08:21:19 EDT FATAL: invalid data in file "000102BD0072.0020.backup" The indicated