From: | "Carlson, James \(Jim\)" <jcarlson(at)rti(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | FW: [NOVICE] Creating a new server |
Date: | 2006-11-14 18:31:28 |
Message-ID: | 5C7823A154D8384CBDBE8F20F2038FA8CF0E39@rtpwexc10.RCC_NT.RTI.ORG |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have an old server that is still working faithfully. It is running Red
Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
I am concerned is closer than I want it to be, I have set up a shinny
new server running Red Hat Enterprise 4.
I am trying to migrate the database from the old server to the new.
Until I get things up and running on the new server, I do not want to do
anything that I fear may cause damage or stop the server from working.
This includes a re-boot. I am interested in the least impacting
migration strategy.
I tried
>pg_dumpall > sync-up.db
Connected to template1...
Psql: FATAL 1: user "jcarlson" does not exist
I then tried
>createuser jcarlson
Psql: FATAL 1: user "root" does not exist
Createuser: create of user "jcarlson" failed
I have found that I need to change the pg_hba.conf file to change the
authentication mode. In the document it says I need to do a pg_ctl
reload. How impacting will this be to the processes currently working?
As stated earlier, everything is currently working. Is there a way to
pg_dumpall or transfer the database without being a user or having to
reload?
Any suggestions on how to carefully transition this to the new server?
Thanks,
Jim Carlson
From | Date | Subject | |
---|---|---|---|
Next Message | Desmond Coughlan | 2006-11-14 18:34:09 | RE : Re: database design ... |
Previous Message | Leodinei Bielak | 2006-11-14 18:25:24 | Locale configuration with Win XP PostgreSQL 8.1.4 |