unsubscribe

--- Magnus Hagander <mha(at)sollentuna(dot)net> wrote:

> > 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
>

____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs