Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[ADMIN] deinstallation - reinstallation on Mac OS 10.4
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! Christoph Heibl Systematic Botany Ludwig-Maximilians-Universität München Menzinger Str. 67 D-80638 München GERMANY phone: +49-(0)89-17861-251 e-mail:[EMAIL PROTECTED] http://www.botanik.biologie.uni-muenchen.de/botsyst/heibl/ch-home.html
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
On 7/20/07, Christoph Heibl [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4
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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[ADMIN] Deinstallation
Hello again, I've installed Postgres Version 8.1.3 on my Linux machine from sourcecode. Before that, there was already the version 7.4 running. May be a dumn question, but how do I deinstall the Version 7.4? Thanks for your help, Moritz
Re: [ADMIN] Deinstallation
Hi Moritz - you got 8.1.3 going then? Excellent :-D You need to try a number of things to find the exact package for 7.4 to remove. Firstly, see if either apt-get or yum is installed on your system. Then you can do apt-get remove pgsql apt-get remove postgres apt-get remove postgresql (or replace apt-get with yum) - one of the above should work. Make sure BEFORE YOU CONFIRM the uninstall that it is only removing the 7.4 PGSQL binaries and nothing else. Regards Andy Moritz Bayer wrote: Hello again, I've installed Postgres Version 8.1.3 on my Linux machine from sourcecode. Before that, there was already the version 7.4 running. May be a dumn question, but how do I deinstall the Version 7.4? Thanks for your help, Moritz !DSPAM:43fde16715195598417964! -- [EMAIL PROTECTED] Andy Shellam the mail network (Server Support) 0 845 838 0879 www.mailnetwork.co.uk [EMAIL PROTECTED]
Re: [ADMIN] Deinstallation
Moritz, The only problem you'll have with regard to configuration issues, is your local applications might try connecting using the 7.4 client libraries as opposed to the 8.1, however if you didn't add a --prefix option to your configure, it should overwrite the old libraries with the new references (not sure if this is definitely true or not.) All your Postgres configuration files will be inside your data directory (created with initdb). When upgrading from a major version (i.e. 7 to 8) you need to dump the contents of your database from the 7.4 server FIRST using pg_dump BEFORE YOU KILL YOUR OLD SERVER - then when you're up with 8.1, use pg_restore. I found this out the hard way!! It is always best to avoid version conflicts. If I were you, I would do the following: 1. With your 7.4 server running, dump your databases using pg_dump or pg_dumpall 2. Kill your 7.4 server and take a backup of your data directory (e.g. mv /path/to/pg_data /path/to/pg_data.OLD 3. Remove your PGSQL 8.1.3 install (cd into the source directory and do 'make uninstall') 4. Install Yum (download RPM for your linux distro from http://rpmseek.com/rpm-pl/yum.html?hl=comcs=yum:PN:0:0:0:0) 5. Use 'yum remove postgresql' to get rid of 7.4 6. Re-install your PGSQL 8.1.3 install (cd into the source directory and do 'make install') 7. initdb a new data directory (DON'T use your old one) and configure your 8.1 server 8. Start up your 8.1 server 9. Restore your dump using pg_restore 10. Configure user access in pg_hba.conf The reason I've said to remove the PG 8.1.3 install first is that when removing 7.4, it might inadvertently remove the 8.1.3 libraries as well (if they've taken over the 7.4 ones.) Note I've confirmed on Redhat Fedora the package is called postgresql - which is v7.4. Regards Andy Moritz Bayer wrote: Hi Andy, I guess I can call you my teacher pretty soon :-) Yes, the installation worked fine, the configuration isn't done yet. I've the feeling, that there are some conflicts with the old version, although I followed the installation-procedere defined in the INSTALL-file of the source-package and also from the book Beginning Database with PostgreSQL from Neil Matthew. So I want to get rid of the old version and start the configuration again. Now the System has neither apt-get nor yum installed. Do you have the rpm or source to get both/either of one? Thank you again, Moritz ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org