X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F13513AA0B4 for ; Mon, 20 Dec 2004 17:30:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05665-04 for ; Mon, 20 Dec 2004 17:30:35 +0000 (GMT) Received: from web51307.mail.yahoo.com (web51307.mail.yahoo.com [206.190.38.173]) by svr1.postgresql.org (Postfix) with SMTP id 908AA3AA096 for ; Mon, 20 Dec 2004 17:30:34 +0000 (GMT) Received: (qmail 40700 invoked by uid 60001); 20 Dec 2004 17:30:33 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=leEu6/ZeCErl2h9Xf6dQRhDoFzSSOclh92uvmlRJm6JyaCnXLZpTH+PeX5fAnG4rprk4s5N9mRBBp94gzQMFGhE+E5DgD1YKZz2DQ1GZsQg5zT/6NdNLwlcgQ+m42y+rHowwGYpKiPCoadWqj5EO2Vp/MiTiuKIhJ1eh8N9Ngy8= ; Message-ID: <20041220173033.40698.qmail@web51307.mail.yahoo.com> Received: from [65.218.182.242] by web51307.mail.yahoo.com via HTTP; Mon, 20 Dec 2004 09:30:33 PST Date: Mon, 20 Dec 2004 09:30:33 -0800 (PST) From: sarlav kumar Subject: Re: Postgres version change - pg_dump To: pgsqlperform In-Reply-To: <41C706E3.5040302@foo.at> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1398071374-1103563833=:36058" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.708 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/248 X-Sequence-Number: 9623 --0-1398071374-1103563833=:36058 Content-Type: text/plain; charset=us-ascii 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. --0-1398071374-1103563833=:36058 Content-Type: text/html; charset=us-ascii
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. --0-1398071374-1103563833=:36058--