Re: [ADMIN] Disconnecting non active (IDLE ) users

2007-02-28 Thread Ezequias Rodrigues da Rocha
I would like to know how postgresql defines that a connection is inactive. I have the same problem but in the future I couldn't restart my server every day. Any explanation ? Ezequias 2007/2/26, Goran Rakic [EMAIL PROTECTED]: I have installed POSTGRESQL 8.2 on W2K3 32bit , 100 users connecting

Re: [ADMIN] Disconnecting non active (IDLE ) users

2007-02-28 Thread Shane Ambler
Ezequias Rodrigues da Rocha wrote: I would like to know how postgresql defines that a connection is inactive. I have the same problem but in the future I couldn't restart my server every day. I believe IDLE = not currently processing a query / sending data back to client. Any explanation ?

Re: [Bulk] Re: [ADMIN] Disconnecting non active (IDLE ) users

2007-02-28 Thread Ted Byers
- Original Message - From: Ezequias Rodrigues da Rocha [EMAIL PROTECTED] To: Goran Rakic [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Wednesday, February 28, 2007 11:01 AM Subject: [Bulk] Re: [ADMIN] Disconnecting non active (IDLE ) users I would like to know how

[ADMIN] UNSUBSCRIBE

2007-02-28 Thread francis feh
"They took us away from our homelandAnd we are slaving down here in BabylonThey are waiting for an opportunityFor the Black Starliner which is to come "sisqo MSN Messenger : appels gratuits de PC à PC partout dans le monde !

[ADMIN] system tables inquiry db Link inquiry

2007-02-28 Thread Karthikeyan Sundaram
Hi, We are using Postgres 8.1.0 Question No 1: = There are lots of system tables that are available in postgres. For example pg_tables will have all the information about the tables that are present in a given schema. pg_views will have all the information about the views for

Re: [ADMIN] [SQL] system tables inquiry db Link inquir

2007-02-28 Thread Gary Chambers
I want to find all the sequences. What is the system tables that have the information about all the sequences? psql -E -U user db \ds Capture the query that psql sends to the server. Can't help with the dblink -- sorry. -- Gary Chambers // Nothing fancy and nothing Microsoft!

Re: [ADMIN] [SQL] system tables inquiry db Link inquiry

2007-02-28 Thread Scott Marlowe
On Wed, 2007-02-28 at 12:19, Karthikeyan Sundaram wrote: Hi, We are using Postgres 8.1.0 Stop. Do not pass go, do not collect $200. Update your postgresql installation now to 8.1.8. There were a lot of bugs fixed between 8.1.0 and 8.1.8. After that... Question No 1: =

[ADMIN] pg_dump error

2007-02-28 Thread Karthikeyan Sundaram
Hi, I am using 8.2.1 on my dev server. When I do a pg_dump, I am getting an error message. pg_dump -U postgres podcast -t channel pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn How can I resolved this? What may be the problem? Because of this, I am

Re: [ADMIN] pg_dump error

2007-02-28 Thread Karthikeyan Sundaram
Hi Joshua, Thanks for your reply. No, I recently installed (fresh installation) from scratch. Regards skarthi From: Joshua D. Drake [EMAIL PROTECTED] To: Karthikeyan Sundaram [EMAIL PROTECTED] CC: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [ADMIN] pg_dump error

Re: [ADMIN] pg_dump error

2007-02-28 Thread Joshua D. Drake
Karthikeyan Sundaram wrote: Hi, I am using 8.2.1 on my dev server. When I do a pg_dump, I am getting an error message. pg_dump -U postgres podcast -t channel pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn How can I resolved this? What may be

Re: [ADMIN] pg_dump inquiry

2007-02-28 Thread Bricklen Anderson
Karthikeyan Sundaram wrote: Hi, I have to dump only 10 tables out of 100 tables. In the pg_dump utility given by postgres there is an option called -t followed by table name. In that option, if I give more than 1 table, it's not accepting. How can I get the dump in one stroke

[ADMIN] please unsubscribe

2007-02-28 Thread Moginraj Mohandas

[ADMIN] pg_hba.conf stuff

2007-02-28 Thread Rob van der Linde
Hi all, I have a server (Ubuntu 6.10 to be exact) running PostgresQL 8.1.4. On that server I have a user account, called ynui, and I also have a postgres user called ynui, they have the same password. Now the server's IP is 192.168.0.1 My main postgres conf has in it: listen_addresses =

Re: [ADMIN] pg_hba.conf stuff

2007-02-28 Thread Jeff Frost
On Thu, 1 Mar 2007, Rob van der Linde wrote: On that server I have a user account, called ynui, and I also have a postgres user called ynui, they have the same password. Now the server's IP is 192.168.0.1 My main postgres conf has in it: listen_addresses = 'localhost,192.168.0.1' my

[ADMIN] pg_dump inquiry

2007-02-28 Thread Karthikeyan Sundaram
Hi, I have to dump only 10 tables out of 100 tables. In the pg_dump utility given by postgres there is an option called -t followed by table name. In that option, if I give more than 1 table, it's not accepting. How can I get the dump in one stroke for all the 10 tables? Please

Re: [ADMIN] pg_hba.conf stuff

2007-02-28 Thread Jeff Frost
Yes, pgadmin3 uses .pgpass to store its connection info - so that's your likely culprit. On Thu, 1 Mar 2007, Rob van der Linde wrote: I had a .pgpass file in the home directory of the client PC. It's possible PgAdmin III or some other program created it. -- Jeff Frost, Owner [EMAIL