Re: db problem

From: Aarni <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: "Daniel Phlander" <phlander(at)friendnet(dot)org>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: db problem
Date: 2003-07-01 07:35:10
Message-ID: 200307011035.10940.aarni.ruuhimaki@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Daniel,

As far as I remember I got this working ok with

pg_dumpall -c > backup

and

psql -e template1 < backup

But why not just upgrade the other machine too ?

BR,

Aarni

On Monday 30 June 2003 18:33, you wrote:
> Hello!
> I have a problem:
> I have installed PostgreSQL 7.3.3 and I have also put in the db a (
> /usr/local/pgsql/bin/pg_dumpall > backup.sql ), which I made from a
> PostgreSQL 7.2.4. backup.sql; has uploaded with no problem, but now in the
> applications on which I work I have to make backup.sql from PgSQL 7.3.3 and
> to put into PgSQL 7.2.4., but I see this is not working (I have errors). I
> want to know how can I put a backup.sql made on a PgSQL 7.3.3 and to upload
> it into PgSQL 7.2.4. ? I look forward to hear from you! Thanks.
> Daniel

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola
FINLAND

info(at)kymi(dot)com / aarni(dot)ruuhimaki(at)kymi(dot)com

05 - 3755 035 / 050 - 4910 037
-------------------------------
Linux RedHat 7.3. / KDE 3.0
-------------------------------

In response to

  • db problem at 2003-06-30 15:33:50 from Daniel Phlander

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2003-07-01 07:38:04 Hierarchical Re: connectby_reverselookup()
Previous Message Josh Berkus 2003-07-01 03:31:07 Re: jobs mailling list: pgsql-jobs@postgresql.org ?