[ADMIN] PostgreSQL internals and implementation of transactions

2004-12-17 Thread Artur Pietruk
Hi, I'm happy user of PostgreSQL for some years. I'm intrested to confirm how exactly transaction engine is implemented in current PostgreSQL version. I made my own findnings, based on my personal experiences through years of using PGSQL, and by reading some pgsql docs and presenta

[ADMIN] unsubscribe pgsql-admin

2004-12-17 Thread mjmayfield
unsubscribe pgsql-admin

Re: [ADMIN] Notifications

2004-12-17 Thread Michael Fuhr
On Fri, Dec 17, 2004 at 01:01:34PM -, Donald Fraser wrote: > Looking at our software, which is java, the problem lies in the > implementation of receiving NOTIFY messages. It uses a separate thread to > check the input stream of the socket for incoming data. The problem is Are you just lo

Re: [ADMIN] archive is compressed - any data will not be available

2004-12-17 Thread Tom Lane
"Iain" <[EMAIL PROTECTED]> writes: > I was given a set of 3 dump files (in a tar.gz archive) generated by a 7.1 > DB that I'm trying to import into another 7.1 DB. 2 of the files (the > smaller ones) restore no problems, but one gives the above mentioned > message. Apparently you are trying to loa

Re: [ADMIN] Notifications

2004-12-17 Thread Donald Fraser
Hello again, I had to rush off to a Christmas meal last night, hence the late reply Well today I looked extensively into the problem and discovered that the NOTIFY messages are arriving outside the firewall. I used psql which itself connected to the database with ssl and received its own NOTI

[ADMIN] archive is compressed - any data will not be available

2004-12-17 Thread Iain
Hi All, I'm hoping that soemone can explain this error message to me and give me an idea of how to proceed. I was given a set of 3 dump files (in a tar.gz archive) generated by a 7.1 DB that I'm trying to import into another 7.1 DB. 2 of the files (the smaller ones) restore n