X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6CC2C5293D for ; Thu, 18 Aug 2005 12:46:17 -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 99129-10 for ; Thu, 18 Aug 2005 15:46:12 +0000 (GMT) Received: from netbox.unitech.com.ar (unknown [200.32.92.34]) by svr1.postgresql.org (Postfix) with ESMTP id D5F3552917 for ; Thu, 18 Aug 2005 12:46:07 -0300 (ADT) Received: from [192.168.1.237] (dariop.unitech.com.ar [192.168.1.237]) by netbox.unitech.com.ar (8.11.6/8.11.6) with ESMTP id j7IGhEE29101; Thu, 18 Aug 2005 12:43:19 -0400 Received: from 127.0.0.1 (AVG SMTP 7.0.338 [267.10.12]); Thu, 18 Aug 2005 12:45:58 -0300 From: "Dario" To: "Magnus Hagander" , "Dirk Kalp" , Subject: Re: Server Won't Start On a Copy of Its Own Data Folder Date: Thu, 18 Aug 2005 12:45:58 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE094693@algol.sollentuna.se> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.066 required=5 tests=[AWL=0.066] X-Spam-Level: X-Archive-Number: 200508/237 X-Sequence-Number: 18556 Did you check file ownership and permissions? Greetings. -----Mensaje original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]En nombre de Magnus Hagander Enviado el: lunes, 15 de agosto de 2005 16:07 Para: Dirk Kalp; pgsql-admin@postgresql.org Asunto: Re: [ADMIN] Server Won't Start On a Copy of Its Own Data Folder > 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. > 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 > > Windows comes back and tells me that the service started and > stopped. The Windows > EventLog show that the postgres server was sent a start > control, entered the running state and > then entered the stopped state. There was nothing new in the > pg_log folder to provide > any clue. This is very weird - it should normally log *something*. There is nothing from postgresql in the eventlog? > Based on what I've gleaned on reading some of the past mail > archives, I thought that this should > work. Have I misunderstood something? It should,m as long as they are on the same version. And it should absolutely log an error. Can you try starting the database manually using pg_ctl (not as a service) and see if you get more errors then? Remember to start it from a runas:ed shell, so you run it as the same user. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings