Re: [ADMIN] psql: could not connect to server: Network is unreachable

2006-01-04 Thread Pandurangan R S
Hi, can you check if postmaster is running on your machine using the following command ps -aef | grep postmaster Also check check if postgres is listening on port 5432 using netstat -na | grep ':5432' On 1/4/06, markos <[EMAIL PROTECTED]> wrote: > Is the server running on host "localhos

Re: [ADMIN] PostgreSQL 7.4.10 hanging on delete

2005-12-21 Thread Pandurangan R S
When the delete statements hangs, look into the pg_locks table, to check if the delete statement is waiting because it has conflict with rows locked by other transactions. On 20 Dec 2005 16:21:53 +, Jonathan Parkin <[EMAIL PROTECTED]> wrote: > I have a reasonably large, live, system-critical d

Re: [ADMIN] Some strange issues with VACUUM on one table.

2005-12-20 Thread Pandurangan R S
I faced a similar situation sometime back in postgres 7.3.4 and i did the following steps and got the problem fixed. 1. Increase max_fsm_pages (may need to increase max_fsm_relations also if you have many objects) 2. Reindex the indexes which have grown very big (find them using pg_class table) 3

Re: [ADMIN] Problem in starting Postgres Database

2005-12-11 Thread Pandurangan R S
Hi Jey, Looks like there is some problem with directory permissions. Btw, how do you start the DB? (what is the username, command you use) Regards Pandu On 12/10/05, Jey <[EMAIL PROTECTED]> wrote: > > Hi, > > We are using Postgres 7.4.3, in Linux ES 3.0 Version > > While I try to start the post

Re: [ADMIN] initdb fails

2005-12-07 Thread Pandurangan R S
Hi, The following link will help you http://www.powerpostgresql.com/Downloads/annotated_conf_80.html On 12/7/05, Anne M. Hammond <[EMAIL PROTECTED]> wrote: > This is running on a Solaris 8 machine. > > I installed V 7.4.7 to use with OpenACS. > > lcd[34]% /usr/local/pgsql/bin/initdb -D /usr/loca