[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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
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, should I be worried? What are the consequences? Thanks From: Andrew Sullivan <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Unable to connect to a specific database Date: Mon, 16 Jan 2006 12:38:09 -0500 On Fri, Jan 13, 2006 at 09:19:30PM -0500, Christopher Browne wrote: > It is possible that you have corrupted the database by issuing "kill > -9." If that's true, then WAL doesn't work. kill -9 shouldn't be any more harmful than a machine crash. That is to say, it's very bad news, but it shouldn't actually corrupt the database. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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! Learn more.
[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) Thanks much Sally _ Mothers Day is May 9. Make it special with great ideas from the Mothers Day Guide! http://special.msn.com/network/04mothersday.armx ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[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 Thanks Sally _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[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 2004 for up-to-date election news, plus voter tools and more! http://special.msn.com/msn/election2004.armx ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[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 waste of space) Thanks Sally ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
