Skip site navigation (1) Skip section navigation (2)

Re: Creating a new server

From: "Carlson, James \(Jim\)" <jcarlson(at)rti(dot)org>
To: "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Creating a new server
Date: 2006-11-13 21:59:13
Message-ID: 5C7823A154D8384CBDBE8F20F2038FA8CF0DA8@rtpwexc10.RCC_NT.RTI.ORG (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Okay, I tried 
>pg_dumpall > sync-up.db
Connected to template1...
Psql: FATAL 1:  user "jcarlson" does not exist


I tried to use the -U option without success. How do I add a user ore
determine a user that will work for pg_dumpall

Thanks,
Jim Carlson       


-----Original Message-----
From: Richard Broersma Jr [mailto:rabroersma(at)yahoo(dot)com] 
Sent: Monday, November 13, 2006 4:43 PM
To: Carlson, James (Jim); pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Creating a new server

> 
> >pg_dump [database name] > sync-trial.db
> 
> Connected to template1...
> 
> Psql: FATAL 1:  user "jcarlson" does not exist


pg_dump will only dump a particular database.  if you want users et. al.
you will need to use
pg_dumpall.  This is the way to move a database from an old version of
7.2 to 8.1.5, 8.2.


> I do not know if pg_dump is the best way to do this, but I have
included
> it in the question to indicate what I attempted. If pg_dump is the
> correct path to follow, how do I address the error?


If you are really concerned about having a "hot stand-by" fail over
machine you can home-brew a
solution using Point In Time Recovery, or you can use a robust solution
like slony.

http://www.postgresql.org/docs/8.1/interactive/backup.html
http://gborg.postgresql.org/project/slony1/projdisplay.php
http://www.commandprompt.com/products/mammothreplicator

Regards,

Richard Broersma Jr.

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-11-13 22:08:29
Subject: Re: [NOVICE] Creating a new server
Previous:From: jennifer llerenaDate: 2006-11-13 21:59:07
Subject: methodology tuning

pgsql-general by date

Next:From: Richard Broersma JrDate: 2006-11-13 22:08:29
Subject: Re: [NOVICE] Creating a new server
Previous:From: gonzalesDate: 2006-11-13 21:50:27
Subject: Re: Speed of postgres compared to ms sql, is this

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group