[ADMIN] Unable to connect to a specific database

I had to kill a vacuum in the middle with -9. I shut down and restarted the postgres server several times after that but I am unable to connect to the db that I was initially running vacuum on I'm doing "psql dbname" and it hangs for a while. I'm still waiting. Any ideas? Thanks

Re: [ADMIN] Unable to connect to a specific database

Well after kill -9, it was in recovery mode but I restarted the server again. It took a while (~ 45min) but it connected again. I have noticed that after a vacuum it takes a while to connect for the first time. You mentioned kill -9 is very bad news. Everything seems to be working fine now, shou

[ADMIN] Separating a single database into different disks

I wanted to find out how I can split one database into different disk partitions. I will very soon be running out of data space . What is the best (safest) way to do this. Any links to docs, ideas appreciated Urgent! Thanks Sally     There are now three new levels of MSN Hotmail Extra Storage!

[ADMIN] How much extra free disk space does postgres need?

Quicik quiestion: After all the data is loaded and indexes are created does anyone know what the minimum additional disk space postgres requires? Thanx Sally There are now three new levels of MSN Hotmail Extra Storage! Learn more.

[ADMIN] postgres mirroring (real-time)

Does anyone know of a good way of implementing postgres real-time mirroring? Whether it's a program that's already out there or whether it is something that can be done by the DBA? I know there is one in contrib called dbmirror but does it actually work well (it seems to also require pgperl) Tha

[ADMIN] pg_restore quick question

I want to dump a database containing about five tables, each containing about 25 million records. I wanted to run pg_restore per table all at the same time. Would this have any undesirable consequences. I tried it on a smaller database and it seems to work fine. Let me know your thoughts ASAP Tha

[ADMIN] VACUUM failing ??!!

After running for more than 24 hrs (I have a large db), vacuum failed with this message: ERROR: failed to re-find parent key in "pg_type_typname_nsp_index" Has anybody encountered this before? Thanks much Sally _ Check out Election

[ADMIN] primary key and the default index operator class

I am trying to figure out how I can change the default operator class of the index created for my primary key field. Is it even possible since I am not able to find the syntax? Or do I need to create the primary key and then an additional index with the operator class I want. (It would be a wast