[ADMIN] could not create IPv6 socket !

2005-09-24 Thread Bui Phu Ngot
Dear all,   I am a newbie to postgresql. After installing Postgresql 8.0.3, I run postmaster and get an error (log). Please help me ! Thanks in advance.   Bui Phu Ngot     /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data LOG: could not create IPv6 socket: Address family not supported by

Re: [ADMIN] could not create IPv6 socket !

2005-09-24 Thread Aldor
Hi, i also get this error message but only at one of my database servers. I'm not sure, but I have experienced some other IPv6 issues on the same server. I think somebody turned on the IPv6 protocole on the server and didn't declare in postgres the IPv6 address. Check if this is also true in your

Re: [ADMIN] PostgreSQL configuration problem

2005-09-24 Thread Andy
Title: Message Do you vacuum the database? It is very important if you insert and delete lot of rows. I think this is your problem.   Best regards, Andy. - Original Message - From: Gandeed Phanibhushan Rao-A18356 To: pgsql-admin@postgresql.org Sent: Monday, Septembe

[ADMIN] Slony1-1.1.0: UNSUBSCRIBE SET and SUBSCRIBE SET

2005-09-24 Thread Aldor
Hi, I have a master database and a slave database replicated with Slony. The config of the cluster: --- CONFIG START --- cluster name = $CLUSTERNAME; node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST port=$MASTERPORT user=$REPLICATIONUSER password=$MASTERPASS'; node 2 admin connin

[ADMIN] Slony1-1.1.0: Triggers are making other things slower?

2005-09-24 Thread Aldor
Hi, I don't really know how Slony works internally but I know that it uses some triggers for getting out new transactions. The config of my Slony cluster: --- CONFIG START --- cluster name = $CLUSTERNAME; node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST port=$MASTERPORT user=$REP

Re: [ADMIN] could not create IPv6 socket !

2005-09-24 Thread Tom Lane
Aldor <[EMAIL PROTECTED]> writes: >> LOG: could not create IPv6 socket: Address family not supported by protocol > i also get this error message but only at one of my database servers. > I'm not sure, but I have experienced some other IPv6 issues on the same > server. I think somebody turned on th

Re: [ADMIN] Hi.........

2005-09-24 Thread Jim C. Nasby
Take a look at http://pgfoundry.org/projects/newsysviews/ On Fri, Sep 23, 2005 at 12:57:31PM +0530, sandhya wrote: > Is there any way/any SQL query of getting information regarding users. > Like > 1) To Display all the databases under Particular user > 2) To Display the timings of login and l