Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9439D9FB97F for ; Tue, 31 Jul 2007 06:21:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 44854-10 for ; Tue, 31 Jul 2007 06:19:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ipmail02.adl2.internode.on.net (ipmail02.adl2.internode.on.net [203.16.214.141]) by postgresql.org (Postfix) with ESMTP id 472399FB95E for ; Tue, 31 Jul 2007 06:19:35 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.19,202,1183300200"; d="scan'208";a="160349881" Received: from ppp247-71.static.internode.on.net (HELO DevBox.local) ([203.122.247.71]) by ipmail02.adl2.internode.on.net with ESMTP; 31 Jul 2007 18:49:33 +0930 Message-ID: <46AEFEA2.7030500@Sheeky.Biz> Date: Tue, 31 Jul 2007 18:49:30 +0930 From: Shane Ambler User-Agent: Thunderbird 2.0.0.5 (Macintosh/20070716) MIME-Version: 1.0 To: Christoph Heibl CC: pgsql-admin@postgresql.org Subject: Re: deinstallation - reinstallation on Mac OS 10.4 References: <34182537-265F-4A46-BDEA-9876AF401A99@gmx.net> <194E8AE5-C0E4-40A7-95BD-1365B048FEB7@gmx.net> <46A62D5A.4030907@productivitymedia.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/350 X-Sequence-Number: 26331 Christoph Heibl wrote: > >> run this in the command line >> >> locate postmaster.pid >> or >> find / -name "postmaster.pid" -print >> >> that should locate any postmaster files and then remove whatever looks >> like the postmaster.pif file > > Thank you! I found postmaster.pid in usr/local/pgsql/data. I deleted the > whole pgsql directory and installed postgres again using the following > commands: > > ./configure > make > sudo make install > sudo mkdir /usr/local/pgsql/data > sudo chown postgres /usr/local/pgsql/data > su postgres > /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > > When I then try to start the PosrgreSQL-server via > > /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data > > the terminal gets "stuck" (i.e. no prompt appears ) after six lines of > output: > > LOG: database system was shut down at 2007-07-25 09:38:00 CEST > LOG: checkpoint record is at 0/42C258 > LOG: redo record is at 0/42C258; undo record is at 0/0; shutdown TRUE > LOG: next transaction ID: 0/593; next OID: 10820 > LOG: next MultiXactId: 1; next MultiXactOffset: 0 > LOG: database system is ready > > There is no explicit error message. What can be wrong? > What directory do I have to cd to in order to execute > "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data"? > Did I omit an important step? > > Thanks for your ideas! > Christoph > The last line there is what you are interested in - it's ready. You may be mislead by the first line - that comes from initdb which basically starts the server to setup the system catalogs etc. then stops it. In the Terminal when you give a command you don't get your cursor back until the command has finished running. As you want the server to continue running you can add & after the command which will allow the command to run in the background. (that would include a space and then the & after the last character in the command) If you have a startupitems folder to start postgresql on startup then you can also use that to start/stop postgresql manually with - sudo /Library/StartupItems/PostgreSQL/PostgreSQL start -- Shane Ambler pgSQL@Sheeky.Biz Get Sheeky @ http://Sheeky.Biz