From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: Kevin Grittner <Kevin.Grittner@wicourts.gov>, "pgsql-admin@postgresql.org"
	<pgsql-admin@postgresql.org>, "ian.lea@gmail.com" <ian.lea@gmail.com>
Date: Tue, 24 Aug 2010 21:25:38 -0700
Subject: Re: trouble restoring database
Thread-Topic: [ADMIN] trouble restoring database
Thread-Index: ActD04qVceTE8v9sTZaBtADFOUZe1gAOgceK
Message-ID: <C899E952.C178%tsakai@gallo.ucsf.edu>
In-Reply-To: <AANLkTim0u4kHBUhFjQh28q3wccTUTRbppEzk27-WRC4m@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-Entourage/13.4.0.100208
acceptlanguage: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi Scott,

Thank you for your quick tips.  I shall remember zcat (and
hopefully others).

Regards,

Tena Sakai


On 8/24/10 2:30 PM, "Scott Marlowe" <scott.marlowe@gmail.com> wrote:

> On Tue, Aug 24, 2010 at 3:22 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote=
:
>> Having said that, I think Ian is correct that I was missing -c flag in t=
he
>> command below:
>> =A0gunzip ..../dumpall20100822.0.gz | /usr/local/pgsql/bin/psql -f - pos=
tgres
>=20
> Quick tip, you can use zcat to get the output of a gzipped file like:
>=20
> zcat ..../dumpall20100822.0.gz|psql
>=20
> There's also zgrep, zless, zegrep, zxpdf, and zdiff.  All do what it
> looks like they do.
>=20
>=20
>> Since the file got uncompressed, I am now running the command:
>> =A0psql -f /home/tsakai/Notes/postgres/dumpall20100822.0
>> and I think it is working. =A0It is giving messsages:
>> =A0ERROR: =A0role "postgres" already exists
>> =A0STATEMENT: =A0CREATE ROLE postgres;
>> =A0ERROR: =A0database "testdb" already exists
>> =A0STATEMENT: =A0CREATE DATABASE testdb WITH TEMPLATE =3D template0 OWNE=
R =3D
>> postgres ENCODING =3D 'UTF8';
>> =A0LOG: =A0checkpoints are occurring too frequently (5 seconds apart)
>> =A0HINT: =A0Consider increasing the configuration parameter
>> "checkpoint_segments".
>>=20
>>=20
>> The last 2 lines are repeated many, many times. =A0This is not terribly
>> Serious, is it? =A0(I will fix it via postgresql.conf file shortly.)
>=20
> No.  It's just telling you that from a performance perspective things
> would be faster with more checkpoint segments.  Unless you spend a
> fair portion of your day restoring dbs, it's probably not big deal.
> If your machines only do a little writing at a time then you can
> probably leave it.  However, increasing checkpoint segments does help
> a lot if you do handle a fair bit of writes, and it's cheap and easy
> to do.