<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body><BR><BR><BR>How I can do the redirect the stderror ? I'm sorry I'm just beginning with Postgresql and I don't have experience?!<BR>
Thaks<BR><BR>
<HR id=stopSpelling>
<BR>
> Date: Wed, 28 Feb 2007 22:33:10 +0100<BR>> From: szajmi@gmail.com<BR>> To: fedora-list@redhat.com<BR>> Subject: Re: retoring a PostgreSQL database from one server to another<BR>> <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>> > and I have this error message when I run the PgAdminIII to connect my data<BR>> > base:<BR>> > "error relation pg_settings not found " & " error relation pg_user not<BR>> > found"<BR>> ><BR>> > and when I use the commands:<BR>> > psql -l<BR>> > ERROR: relation "pg_catalog.pg_user" not found<BR>> ><BR>> > notice that when I make restore , I have many error message about missing<BR>> > relation ;<BR>> ><BR>> > please can anybody help me to resolv my problem<BR>> > thanks for advance<BR>> <BR>> Are you doing the restore as the postgres user?<BR>> Also, it's useful to redirect stderror to a file when doing the<BR>> restore, so you can inspect it later.<BR>> <BR>> Andras<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><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>