From: mlaks@verizon.net <mlaks@verizon.net>
To: pgsql-admin@postgresql.org
Subject: psql instead of pg_restore
Date: Mon, 6 Dec 2004 01:13:28 -0500
Message-ID: <200412060113.28639.mlaks@verizon.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mlaks@verizon.net
Subject: Re: psql instead of pg_restore
In-Reply-To: <200412060113.28639.mlaks@verizon.net>
References: <200412060113.28639.mlaks@verizon.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox