From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Demian Quinonez <dgq111(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: restoring with sql script |
Date: | 2007-08-10 05:44:15 |
Message-ID: | 1186724655.11237.215.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 2007-08-08 at 15:17 -0700, Demian Quinonez wrote:
> Help!
>
> I am creating a fail over server and one element of my system is using
> postgresql 8.0. I created a dump of the current DB and I want to
> restore "as is" on the fail over server. On the fail over I am using
> the command "psql -U <username> < <sql script>" to try to restore the
> the DB but when I press enter it does not ask me for my password and
> goes directly to the FATAL error of password is not authenticated.
> Any idea what I am doing wrong? I am following the instructions given
> by our vendor in how to back up and restore the pg DB.
Try adding -W
--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Ashish Karalkar | 2007-08-10 07:58:01 | Re: restoring with sql script |
Previous Message | Decibel! | 2007-08-08 22:20:21 | Re: buffer page lock vs tuple lock (?) |