Re: [ADMIN] developer deleted a database directory, postgres won't start

2000-11-29 Thread selkovjr
> One of the developers deleted a directory from postgress's data > directory. (He mistakenly believed this was "just like mysql" where > he could drop the database like that) > > At any rate, now postgres just dies when it's attempting to > start, how can I fix this? I am not 100% sure wheth

[ADMIN] shmget failed blues on Solaris8 (pointer for Solaris FAQ)

2000-11-29 Thread Dirk Lutzebaeck
Just to let you know how I wasted my time the last 3 hours on the famous shmget failed error: Solaris has also a minimum shared mem segment size which I had set to 200 bytes according to recommendations I found in the mail archive. Well, until I noticed (after 3 hrs) that the postmasters initial

[ADMIN] Weird DB Shutdowns

2000-11-29 Thread Victor
localhost[/usr/local/pgsql/data]# psql test dbuser Password: psql: The Data Base System is shutting down localhost[/usr/local/pgsql/data]# - I am getting weird DB shutdowns. Anybody experience this before ? Any ideas welcome. What could this

[ADMIN] Perfomance of postgresql-7.0.3-2

2000-11-29 Thread Karla Peralta
Hi, I have some problems with the perfomance when I run my program and I'm just testing in two machines. I have a diskless system. This is what I have: System Configuration: Server Architecture    :    Pentium II Memory  :    64Mb Operating System    :    RedHat 6.2 PostgreSQL

Re: [ADMIN] Perfomance of postgresql-7.0.3-2

2000-11-29 Thread Thomas Wong
Hi, Maybe use less columns/table if possible. It is possible the client to share the load with the server ? Some processing can still be done by the client. Btw, do you measure the system performance (disk access, cpu load, bla bla bla on the OS). I tried using "hdparm" to increase my disk acces