Re: [ADMIN] Please Help... Service fails to start

2009-11-03 Thread Hengky Lie
Dear friends, At last i can solved the problem by running CHKDSK. This program found bad allocation unit on pg_clog folder. After repairing, service can start again. Thank you for your advice. I really appreciate it. Regards, Hengky On Nov 4, 2009, at 2:14 AM, Scott Marlowe wrote: On T

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Kevin Grittner
Scott Marlowe wrote: >> -- Dear Ian Lea, i guess 10.0.0.1/24 is the same as 10.0.0.0/24 >> as the mask '24' means that the first 3 octets (24 bits from the >> left hand side) must match ie both mean simply 10.0.0.* > > Actually 10.0.0.0/24 means that the right hand 24 bits don't matter, > so

Re: [ADMIN] Please Help... Service fails to start

2009-11-03 Thread Scott Marlowe
On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie wrote: > What exactly file pg_clog/0085 exactly is ? Thank you for any advice. Now > i'm trying to check file permission and antivirus. > pg_clog contains the commit log. Once things in pg_xlog have been committed to disk when the background writer get

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Scott Marlowe
On Tue, Nov 3, 2009 at 1:53 AM, Shruthi A wrote: > Hi all, > > Thanks a lot for all your replies.  The problem is solved now.  This is the > correct thing to do:    listen_addresses = '*' > And then restart the service. > > Additional notes: > -- Remember to use single quotes around the * else it

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Tim Bruce - Postgres
On Tue, November 3, 2009 10:10, Scott Marlowe wrote: > On Tue, Nov 3, 2009 at 1:53 AM, Shruthi A wrote: >> Hi all, >> >> -- Once this service is started, telneting the server on the given port >> successfully connects. >> -- Dear Ian Lea, i guess 10.0.0.1/24  is the same as 10.0.0.0/24  as the >>

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Scott Marlowe
On Tue, Nov 3, 2009 at 11:26 AM, Kevin Grittner wrote: > Scott Marlowe wrote: > >>> -- Dear Ian Lea, i guess 10.0.0.1/24  is the same as 10.0.0.0/24 >>> as the mask '24' means that the first 3 octets (24 bits from the >>> left hand side) must match ie both mean simply 10.0.0.* >> >> Actually 10.0

Re: [ADMIN] fighting ' in transaction'

2009-11-03 Thread Lewis Kapell
Please see these earlier threads: Is IDLE session really idle? http://archives.postgresql.org/pgsql-admin/2009-06/msg00096.php Idle connections http://archives.postgresql.org/pgsql-admin/2009-10/msg00017.php Lewis Kapell Vladimir Rusinov wrote: Hi! We are having a lot of ' in transaction' p

[ADMIN] fighting ' in transaction'

2009-11-03 Thread Vladimir Rusinov
Hi! We are having a lot of ' in transaction' processes in production database. This does not seems to be big problem now, since they are not taking any big locks. But I'm aware that sometime it can become a problem. Currently I'm just killing all processes that are in 'idle in transaction' for mor

Re: [ADMIN] Need help in enabling remote connection

2009-11-03 Thread Shruthi A
Hi all, Thanks a lot for all your replies. The problem is solved now. This is the correct thing to do:listen_addresses = '*' And then restart the service. Additional notes: -- Remember to use single quotes around the * else it will give syntax error. -- The listen_addresses parameter specif

Re: [ADMIN] can not create user name in Capital letter

2009-11-03 Thread Thomas Kellerer
Emanuel Calvo Franco, 02.11.2009 21:27: I have a trouble in creating user and database in postgres. whenever I create user or databases in capital letters, the names are always converted into names in lower case letter. what's wrong with it? Thanks Dong Try add "" CREATE USER "PepeArgento";