X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CDC0952EE6 for ; Fri, 12 Aug 2005 18:22:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13318-02 for ; Fri, 12 Aug 2005 21:22:28 +0000 (GMT) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by svr1.postgresql.org (Postfix) with ESMTP id 4E86152DFF for ; Fri, 12 Aug 2005 18:22:27 -0300 (ADT) Received: from DELLMOTE ([151.201.138.110]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IL400BFGOPG7PZ8@vms044.mailsrvcs.net> for pgsql-admin@postgresql.org; Fri, 12 Aug 2005 16:22:29 -0500 (CDT) Date: Fri, 12 Aug 2005 17:22:29 -0400 From: "Dirk Kalp" Subject: Server Won't Start On a Copy of Its Own Data Folder To: Message-id: <003201c59f83$f2499d50$7001a8c0@DELLMOTE> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook Express 6.00.2900.2180 Content-type: multipart/alternative; boundary="----=_NextPart_000_002F_01C59F62.6AD3E450" X-Priority: 3 X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.174 tagged_above=0 required=5 tests=[AWL=0.078, HTML_50_60=0.095, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200508/163 X-Sequence-Number: 18482 This is a multi-part message in MIME format. ------=_NextPart_000_002F_01C59F62.6AD3E450 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Server Won't Start On a Copy of Its Own Data Folder 1. Installed the latest 8.0.3 binary on a Windows XP Pro system as a = service to be started on bootup.=20 2. Used psql just to verify that I can connect. 3. Used Windows Control Panel.Administrative Tools.Services to stop the = server cleanly. 4. Made a copy of the PostgreSQL/8.0/data folder 5. Renamed the installed folder as PostgreSQL/8.0/saved-data 6. Renamed the copy of data as PostrgeSQL/8.0/data 7. Used Windows Control Panel.Administrative Tools.Services to start the = server 8. The server fails to come up=20 Windows comes back and tells me that the service started and stopped. = The Windows=20 EventLog show that the postgres server was sent a start control, entered = the running state and=20 then entered the stopped state. There was nothing new in the pg_log = folder to provide any clue. I renamed the saved-data folder back to data and used the Services tool = to start the server with success but further attemps to start it with a copy of the data = folder all fail in the same way. Based on what I've gleaned on reading some of the past mail archives, I = thought that this should work. Have I misunderstood something? I went through this exercise in trying to solve a problem I posted about = on Monday=20 ([ADMIN] Trouble Getting Database Server Started) trying to recover a = database on a computer that may have powered down when the server was running. I = don't know what happened but I can't start the server any more on that computer. My = goal is to install the data folder from that computer on a new install of postgres = on a second=20 computer. Thanks for any help anyone can offer, Dirk Kalp ------=_NextPart_000_002F_01C59F62.6AD3E450 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Server Won't Start On a Copy of = Its Own Data=20 Folder
 
1. Installed the latest 8.0.3 = binary on a=20 Windows XP Pro system as a service to be started on bootup. =
2. Used psql just to verify that I can=20 connect.
3. Used Windows Control = Panel.Administrative=20 Tools.Services to stop the server cleanly.
4. Made a copy of the = PostgreSQL/8.0/data=20 folder
5. Renamed the installed folder as=20 PostgreSQL/8.0/saved-data
6. Renamed the copy of data as=20 PostrgeSQL/8.0/data
7. Used Windows Control = Panel.Administrative=20 Tools.Services to start the server
8. The server fails to come=20 up 
 
Windows comes back and tells me that = the service=20 started and stopped. The Windows
EventLog show that the postgres server = was sent a=20 start control, entered the running state and
then entered the stopped state. There = was nothing=20 new in the pg_log folder to provide
any clue.
 
I renamed the saved-data folder = back to data=20 and used the Services tool to start the server
with success but further attemps to = start it with a=20 copy of the data folder all fail in the same way.
 
Based on what I've gleaned on reading = some of the=20 past mail archives, I thought that this should
work. Have I misunderstood = something?
 
I went through this exercise in trying = to solve a=20 problem I posted about on Monday
([ADMIN] Trouble Getting Database = Server Started)=20 trying to recover a database on
a computer that may have powered down = when the=20 server was running. I don't know
what happened but I can't start the = server any more=20 on that computer. My goal is to
install the data folder from that = computer on a new=20 install of postgres on a second
computer.
 
Thanks for any help anyone can = offer,
Dirk Kalp
 
------=_NextPart_000_002F_01C59F62.6AD3E450--