<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body><BR>I'm restoring the database via the the postgres user, what do want me to do , is there any way to do it ?<BR><BR><BR>
<HR id=stopSpelling>
> Date: Wed, 28 Feb 2007 15:42:44 -0600<BR>> From: bruno@wolff.to<BR>> To: szajmi@gmail.com<BR>> CC: fedora-list@redhat.com<BR>> Subject: Re: retoring a PostgreSQL database from one server to another<BR>> <BR>> On Wed, Feb 28, 2007 at 22:33:10 +0100,<BR>> Andras Simon <szajmi@gmail.com> wrote:<BR>> > On 2/28/07, Beau BOB <man_55@hotmail.fr> wrote:<BR>> > >Hi,<BR>> > ><BR>> > >I have postgresql 7.4.1 and I'm restoring to another server that has<BR>> > >postgresql 7.4.6<BR>> > ><BR>> > >for dumping I'm using :<BR>> > >pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile<BR>> > ><BR>> > >and for restoring I use many methods:<BR>> > >psql -h localhost -U postgres -d template1 -f dbfile<BR>> > ><BR>> > <BR>> > Are you doing the restore as the postgres user?<BR>> <BR>> That is what the -U option to psql specifies. So it looks like he is.<BR>> <BR>> -- <BR>> fedora-list mailing list<BR>> fedora-list@redhat.com<BR>> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list<BR><br /><hr />Exprimez-vous en direct avec Windows Live Messenger ! <a href='http://imagine-msn.com/messenger/launch80/default.aspx?locale=fr-fr&source=joinmsncom/messenger' target='_new'>Windows Live Messenger !</a></body>
</html>