pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: sarlav kumar <sarlavk@yahoo.com>
To: pgsqlperform <pgsql-performance@postgresql.org>
Subject: Re: Postgres version change - pg_dump
Date: Mon, 20 Dec 2004 09:30:33 -0800 (PST)
Message-ID: <20041220173033.40698.qmail@web51307.mail.yahoo.com> (raw)
In-Reply-To: <41C706E3.5040302@foo.at>

Hi,
 
I think I miscommunicated something. I am doing a pg_dump from Postgres 7.3.2. I am restoring it on Postgres 7.4.6 on Fedora Core 3 on a different server.
 
I tried doing the dump and restoring it on the new DB. I did not have any problem with the UNIQUE contraint so far. But I got an error message saying table "session" does not exist, though it does exist in the old database(from where I did the dump). 
 
I also got another error saying "user abc does not exist". On the old DB I have different set of users, with different privileges granted to each of them on the tables. I guess I need to create these set of users in the new DB before doing the dump. Am I right?

I am new to postgres administration. So I am not sure what you mean by "same locale in the new database cluster". Could you please explain or point me to a source where I can learn from?
 
Thanks a lot for the help,
Saranya
 

 


		
---------------------------------
Do you Yahoo!?
 Jazz up your holiday email with celebrity designs. Learn more.

view thread (9+ messages)  latest in thread

Message-ID: <20041220173033.40698.qmail@web51307.mail.yahoo.com>
Permalink:  ../20041220173033.40698.qmail@web51307.mail.yahoo.com/
Also on:    postgresql.org/message-id/20041220173033.40698.qmail@web51307.mail.yahoo.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sarlavk@yahoo.com
  Subject: Re: Postgres version change - pg_dump
  In-Reply-To: <20041220173033.40698.qmail@web51307.mail.yahoo.com>

* 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