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 565B552D46 for ; Mon, 15 Aug 2005 16:48:47 -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 03568-08 for ; Mon, 15 Aug 2005 19:48:30 +0000 (GMT) Received: from web31904.mail.mud.yahoo.com (web31904.mail.mud.yahoo.com [68.142.207.84]) by svr1.postgresql.org (Postfix) with SMTP id 07C1952AF0 for ; Mon, 15 Aug 2005 16:47:54 -0300 (ADT) Received: (qmail 21307 invoked by uid 60001); 15 Aug 2005 19:47:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=YJSWNq0ckjJEXkSMRuI+TAvVwxeCfkJUC6Krvzz4hWaQWxMbwDE+BwDfrAAnV2ic0hW3HqKtng6/jXW/w5Nb+UPmrhJ6hQZ/UugVhkZnd1mZI2innfP3qHFhEZX7bOaxTt70gYEaAZSm3QQhdEX8lZrrQZ/PZH3FR87c8ywQMSQ= ; Message-ID: <20050815194745.21305.qmail@web31904.mail.mud.yahoo.com> Received: from [12.164.192.250] by web31904.mail.mud.yahoo.com via HTTP; Mon, 15 Aug 2005 12:47:45 PDT Date: Mon, 15 Aug 2005 12:47:45 -0700 (PDT) From: asif ali Subject: unsubscribe To: pgsql-admin@postgresql.org In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE094693@algol.sollentuna.se> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.877 required=5 tests=[FROM_ENDS_IN_NUMS=0.516, FROM_HAS_ULINE_NUMS=0.361] X-Spam-Level: X-Archive-Number: 200508/182 X-Sequence-Number: 18501 --- Magnus Hagander 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