pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dario <dario_d_s@unitech.com.ar>
To: Magnus Hagander <mha@sollentuna.net>
To: Dirk Kalp <dkalp@sensormgmt.com>
To: pgsql-admin@postgresql.org
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: <MHEDJHCKDNOEHJKHIOCJKEBCCGAA.dario_d_s@unitech.com.ar> (raw)
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE094693@algol.sollentuna.se>

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




view thread (3+ messages)

Message-ID: <MHEDJHCKDNOEHJKHIOCJKEBCCGAA.dario_d_s@unitech.com.ar>
Permalink:  ../MHEDJHCKDNOEHJKHIOCJKEBCCGAA.dario_d_s@unitech.com.ar/
Also on:    postgresql.org/message-id/MHEDJHCKDNOEHJKHIOCJKEBCCGAA.dario_d_s@unitech.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dario_d_s@unitech.com.ar, mha@sollentuna.net, dkalp@sensormgmt.com
  Subject: Re: Server Won't Start On a Copy of Its Own Data Folder
  In-Reply-To: <MHEDJHCKDNOEHJKHIOCJKEBCCGAA.dario_d_s@unitech.com.ar>
  References: <6BCB9D8A16AC4241919521715F4D8BCE094693@algol.sollentuna.se> <MHEDJHCKDNOEHJKHIOCJKEBCCGAA.dario_d_s@unitech.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox