[ADMIN] postgres 8.4 authentication with LDAP

Hi, I am new to Postgres, but not so new with LDAP. I installed postgres 8.4 with ldap; from 'grep -y ldap config.log': [...] config.log:configure_args=' '\''--with-libraries=/usr/local/lib'\'' '\''--with-includes=/usr/local/include'\'' '\''--enable-thread-safety'\'' '\''--with-openssl'\'' '\''-

[ADMIN] Seek info on 7.4.23 server/8.1.1 psql compatibility issues.

Greetings, I have a functioning 7.4.23 server on Debian 4, 32-bit. I connect fine using 7.4.23 remote clients. Remote connections from an 8.1.1 psql client on SUSE, 64-bit, hang after the password prompt appears and a password is entered. However, the 7.4.23 server log indicates that a valid co

Re: [ADMIN] Help With Database Backup

> Subject: Re: [ADMIN] Help With Database Backup > From: andy-li...@networkmail.eu > Date: Wed, 30 Sep 2009 22:24:27 +0100 > CC: pgsql-admin@postgresql.org > To: chal...@yahoo.com > > Hi, > > > > > Hello there, I am new to PostgreSQL, succeded in running a little > > database on > > my dev.

Re: [ADMIN] Seek info on 7.4.23 server/8.1.1 psql compatibility issues.

Kenneth Banyas writes: > I have a functioning 7.4.23 server on Debian 4, 32-bit. > I connect fine using 7.4.23 remote clients. > Remote connections from an 8.1.1 psql client on SUSE, 64-bit, hang after > the password prompt appears and a password is entered. > However, the 7.4.23 server log indi

[ADMIN] Database recovery due to out of disk space

While implementing a warm standby server lightning struck, the WAL files supposed to be shipped to the warm standby server caused the filing system to be out of disk space. In order to quickly reclaim disk space we removed some of the WAL files written to pg_xlogs (very stupid we know). A corru

Re: [ADMIN] Database recovery due to out of disk space

M4N - Dennis Brouwer writes: > We are trying to recover this database on a different server and > re-indexed all (but one) tables, only one -unimportant- table refuses to > be re-indexed or even dropped. We desperately want to drop this single > table (it's recreated constantly) but we can not

[ADMIN] Re.: Database recovery due to out of disk space

Hi > While implementing a warm standby server lightning struck, the WAL files > supposed to be shipped to the warm standby server caused the filing > system to be out of disk space. In order to quickly reclaim disk space > we removed some of the WAL files written to pg_xlogs (very stupid we >

[ADMIN] Restore a backup from 8.4 to 8.3

I try to restore a backup from 8.4 to 8.3 version but I got a error. Is possible to do this? Thanks.. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] postgres 8.4 authentication with LDAP

Hi, Well I reply to myself... > I am new to Postgres, but not so new with LDAP. > [...] > In pg_hba.conf I have the line (wrapped for email purpose, in the > file, it's a single line): > > hostall all 192.41.170.0/24 ldap > ldapserver=ldap.cs.ait.ac.th ldapport=

[ADMIN] where the stored function meta data can be found?

Hello, everybody I tried to find where in pg_catalog stored functions are stored, but with no success. Are they available in pg_catalog at all? I have to find all the procedures that delete data from one of my tables. I hope there's a better way to do that than simply search function by functi