pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mlaks@verizon.net <mlaks@verizon.net>
To: pgsql-admin@postgresql.org
Subject: pg_dump DATABASE > database.dump -> psql <database.dump vs pg_restore database.dump
Date: Mon, 6 Dec 2004 08:18:15 -0500
Message-ID: <200412060818.16076.mlaks@verizon.net> (raw)

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



Message-ID: <200412060818.16076.mlaks@verizon.net>
Permalink:  ../200412060818.16076.mlaks@verizon.net/
Also on:    postgresql.org/message-id/200412060818.16076.mlaks@verizon.net

 · 

reply

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: pg_dump DATABASE > database.dump -> psql <database.dump vs pg_restore database.dump
  In-Reply-To: <200412060818.16076.mlaks@verizon.net>
  References: <200412060818.16076.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