Обсуждение: deinstallation - reinstallation on Mac OS 10.4

On 7/20/07, Christoph Heibl <christoph.heibl@gmx.net> wrote:
> Dear experts,
>
> I' ve been trying to mirror the harddisk of my old mac via firewire on my
> new computer (Intel Core Duo, OS 10.4.10) which resulted fairly well expect
> that my postgreSQL got screwed up. I then tried to install it once more, but
> this failed. I guess I did not remove all the remaining files before
> installation and I ended up with this failure:
>
> ----------------------------------------------------------------------------------------------------------------
> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$
> ./configure
> [....]
>
> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$
> make
>
> [....]  All of PostgreSQL successfully made. Ready to install.
>
> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$
> make install
> make -C doc install
> gzip -d -c ./postgres.tar.gz | ( cd /usr/local/pgsql/doc/html &&
> /usr/bin/tar xf - )
> /usr/bin/tar: index.html: Cannot open: File exists
> /usr/bin/tar: preface.html: Cannot open: File exists
> /usr/bin/tar: intro-whatis.html: Cannot open: File exists
> /usr/bin/tar: history.html: Cannot open: File exists
> /usr/bin/tar: notation.html: Cannot open: File exists
> /usr/bin/tar: resources.html: Cannot open: File exists
> [....]
> /usr/bin/tar: bookindex.html: Cannot open: File exists
> /usr/bin/tar: LEGALNOTICE.html: Cannot open: File exists
> /usr/bin/tar: stylesheet.css: Cannot open: File exists
> /usr/bin/tar: Read 2560 bytes from -
> /usr/bin/tar: Error exit delayed from previous errors
> make[1]: *** [install] Error 2
> make: *** [install] Error 2
>
> ----------------------------------------------------------------------------------------------------------------
>
> The files seem to exist already but I simply do not find them.
>
> My questions:
> Are there deinstallation protocols for Mac? (I was not able to find any...)
> How can I find and delete these files?
> Or is it something else that hinders me from installing postgres?
>
> I hope to hear from someone who can give me some hints - thanks a lot!
>
>

Not a Mac guy here, but I think you should try running configure with
a different prefix. For example:

./configure --prefix=/usr/local/pgsql-tmp

This will avoid conflicts with old left over files (if any).

regards,
--
Sibte Abbas
EnterpriseDB http://www.enterprisedb.com

On Jul 20, 2007, at 8:19 AM, Christoph Heibl wrote:

> I' ve been trying to mirror the harddisk of my old mac via firewire
> on my new computer (Intel Core Duo, OS 10.4.10) which resulted
> fairly well expect that my postgreSQL got screwed up. I then tried
> to install it once more, but this failed. I guess I did not remove
> all the remaining files before installation and I ended up with
> this failure:
>
> ----------------------------------------------------------------------
> ------------------------------------------
> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$ ./configure
> [....]
>
> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$ make
>
> [....]  All of PostgreSQL successfully made. Ready to install.
>
> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$ make install
> make -C doc install
> gzip -d -c ./postgres.tar.gz | ( cd /usr/local/pgsql/doc/html && /
> usr/bin/tar xf - )
> /usr/bin/tar: index.html: Cannot open: File exists
> /


Why not just move (or delete) the existing PostgreSQL directory
before make install?

If you want to check out what is already there, start Terminal and type:

open /usr/local/pgsql




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

Thanks a lot for your help! By deleting the pgsql directory I get
some steps further. Now I get stuck by a error message saying
"postmaster.pid" already exists, when I try to start postmaster. I am
not really sure what this means because I think I initiated the
database only once, but I guess I have to try a little bit more to
solve this problems.

Best regards,
Christoph Heibl


On 21.07.2007, at 04:40, Sibte Abbas wrote:

> On 7/20/07, Christoph Heibl <christoph.heibl@gmx.net> wrote:
>> Dear experts,
>>
>> I' ve been trying to mirror the harddisk of my old mac via
>> firewire on my
>> new computer (Intel Core Duo, OS 10.4.10) which resulted fairly
>> well expect
>> that my postgreSQL got screwed up. I then tried to install it once
>> more, but
>> this failed. I guess I did not remove all the remaining files before
>> installation and I ended up with this failure:
>>
>> ---------------------------------------------------------------------
>> -------------------------------------------
>> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$
>> ./configure
>> [....]
>>
>> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$
>> make
>>
>> [....]  All of PostgreSQL successfully made. Ready to install.
>>
>> Christoph-Heibls-Computer:~/src/postgresql-8.2.4 Stoffi$
>> make install
>> make -C doc install
>> gzip -d -c ./postgres.tar.gz | ( cd /usr/local/pgsql/doc/html &&
>> /usr/bin/tar xf - )
>> /usr/bin/tar: index.html: Cannot open: File exists
>> /usr/bin/tar: preface.html: Cannot open: File exists
>> /usr/bin/tar: intro-whatis.html: Cannot open: File exists
>> /usr/bin/tar: history.html: Cannot open: File exists
>> /usr/bin/tar: notation.html: Cannot open: File exists
>> /usr/bin/tar: resources.html: Cannot open: File exists
>> [....]
>> /usr/bin/tar: bookindex.html: Cannot open: File exists
>> /usr/bin/tar: LEGALNOTICE.html: Cannot open: File exists
>> /usr/bin/tar: stylesheet.css: Cannot open: File exists
>> /usr/bin/tar: Read 2560 bytes from -
>> /usr/bin/tar: Error exit delayed from previous errors
>> make[1]: *** [install] Error 2
>> make: *** [install] Error 2
>>
>> ---------------------------------------------------------------------
>> -------------------------------------------
>>
>> The files seem to exist already but I simply do not find them.
>>
>> My questions:
>> Are there deinstallation protocols for Mac? (I was not able to
>> find any...)
>> How can I find and delete these files?
>> Or is it something else that hinders me from installing postgres?
>>
>> I hope to hear from someone who can give me some hints - thanks a
>> lot!
>>
>>
>
> Not a Mac guy here, but I think you should try running configure with
> a different prefix. For example:
>
> ./configure --prefix=/usr/local/pgsql-tmp
>
> This will avoid conflicts with old left over files (if any).
>
> regards,
> --
> Sibte Abbas
> EnterpriseDB http://www.enterprisedb.com

Christoph Heibl wrote:
> Thanks a lot for your help! By deleting the pgsql directory I get some
> steps further. Now I get stuck by a error message saying
> "postmaster.pid" already exists, when I try to start postmaster. I am
> not really sure what this means because I think I initiated the database
> only once, but I guess I have to try a little bit more to solve this
> problems.

The existence of postmaster.pid would indicate that postgresql is either
running or was not stopped properly. If it your sure it isn't running
then you can delete the .pid file manually.

If you are familiar with the terminal then ps aux | grep postgres will
list any processes running. If there are any stop postgresql and if the
.pid file remains delete it then start postgresql.



--

Shane Ambler
pgSQL@Sheeky.Biz

Get Sheeky @ http://Sheeky.Biz

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

I hate to sound like a --- but did you read the README on starting the
server?  You start the server by using the postmaster command:

/path/to/postmaster -D /path/to/data

look at the postgresql manual - it's all there.

J
>
>
>
>
>
>
>

> 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

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