From: | "mlaks(at)verizon(dot)net" <mlaks(at)verizon(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_dump DATABASE > database.dump -> psql <database.dump vs pg_restore database.dump |
Date: | 2004-12-06 13:18:15 |
Message-ID: | 200412060818.16076.mlaks@verizon.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi! I just suffered a hard drive failure and restored a database that had been
saved via pg_dump DATABASE >DATABASE.dump. However, instead of doing
pg_restore (which I completely forgot about :( ) ,
I did:
createdb DATABASE then I did
psql DATABASE <DATABASE.dump.
Now I can access my data from the database, but the response is very slow, it
seems as if it is not using all the index's that existed. even if I vacuum
--analyze very vigorously.
I am a bit of a newbie. I am also switching from postgresql-7.2.4 running on
redhat-7.3 to postgreql 7.4.5 running on the latest debian-testing
distribution (sarge). I used all the same enhancements for speeding up
postgresql on my system:
kernel.shmmax = 425000000
in the proper place in /etc/sysctl.conf
and
in the postgresql.conf file
shared_buffers = 48000
max_connections = 512
sort_mem = 4096
effective_cache_size = 4000
wal_buffers = 8
What should I do to fix the situation?
Thanks
Mitchell
From | Date | Subject | |
---|---|---|---|
Next Message | Gourish Singbal | 2004-12-06 14:28:21 | Need Help in Taking Backups |
Previous Message | mlaks@verizon.net | 2004-12-06 06:13:28 | psql instead of pg_restore |