| 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: | 153835.55842.qm@web31802.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gonzales | 2006-11-13 21:50:27 | Re: Speed of postgres compared to ms sql, is this |
| Previous Message | novnov | 2006-11-13 21:36:36 | Re: Speed of postgres compared to ms sql, is this |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jennifer llerena | 2006-11-13 21:59:07 | methodology tuning |
| Previous Message | Carlson, James (Jim) | 2006-11-13 21:06:05 | Creating a new server |