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

Re: Creating a new server

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: "Carlson, James \(Jim\)" <jcarlson(at)rti(dot)org>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Creating a new server
Date: 2006-11-13 21:43:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-novice
> >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.


Richard Broersma Jr.

In response to


pgsql-novice by date

Next:From: jennifer llerenaDate: 2006-11-13 21:59:07
Subject: methodology tuning
Previous:From: Carlson, James (Jim)Date: 2006-11-13 21:06:05
Subject: Creating a new server

pgsql-general by date

Next:From: gonzalesDate: 2006-11-13 21:50:27
Subject: Re: Speed of postgres compared to ms sql, is this
Previous:From: novnovDate: 2006-11-13 21:36:36
Subject: Re: Speed of postgres compared to ms sql, is this

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