Thread: Difficulty installing postgresql on Max OSX Leopard.
I'm working with an open source Electronic Medical Record application 'GNUmed" which uses postgresql. I've had a difficult time installing version 8.4.1 from source code on my Mac.
The best set of instruction i've found is from http://zanshin.net/2009/09/07/installing-postgresql-on-mac-10-6-snow-leopard/, however it did not quite do the trick. Going by the instructions there:
On starting the server:bash-3.2$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ -l server.log start
If I use this command to stop server I get:/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsqsl/data/ -l server.log stoppg_ctl: PID file "/usr/local/pgsqsl/data/postmaster.pid" does not existIs server running?
Creating the db:bash-3.2$ createdb testdbcreatedb: could not connect to database postgres: could not connect to server: No such file or directoryIs the server running locally and acceptingconnections on Unix domain socket "/tmp/.s.PGSQL.5432"?
The server.log entries:postgres cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": No such file or directoryThe file does existls dataPG_VERSION global pg_hba.conf pg_multixact pg_subtrans pg_twophase postgresql.confbase pg_clog pg_ident.conf pg_stat_tmp pg_tblspc pg_xlog postmaster.opts
Also, when attempting to unzip some src files, including the one I got from this site I get this:
tar -zxvf postgresql-8.4.1.tar.gz
tar: Unrecognized archive format: Inappropriate file type or format
tar: Error exit delayed from previous errors.
THis is very strange to me!
The file I'm using came from source forge.
Any hints about this installation is greatly appreciated.
Don Fox
P.S. The app that will using postgresql is written in python.
This type of occurrence seems very unlikely! If it happens to me it should be a common experience to many.
I'm downloading from Mac OS X Snow Leopard. This copy(from http://www.postgresql.org/ftp/source/v8.4.1/) goes into my Downloads dir AND the Trash.
The file in the Trash still has the .zip extension while the one in downloads has only the .tar.
tar -xvf postgresql-8.4.1.tar
tar: Unrecognized archive format: Inappropriate file type or format
tar: Error exit delayed from previous errors.
Previously, on Leopard i's just get the file placed in the Downloads folde? This must be some problem local to my machine??
Any ideas or explanations are greatly appreciated!
I finally got my workable copy of 8.4.1 from Source Forge!
Don Fox
On Oct 30, 2009, at 11:19 AM, Mladen Gogala wrote:
The file you downloaded is probably corrupt. I am not a Mac expert but tar would have unpacked it if it was good.From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Don Fox
Sent: Friday, October 30, 2009 9:03 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Difficulty installing postgresql on Max OSX Leopard.tar -zxvf postgresql-8.4.1.tar.gztar: Unrecognized archive format: Inappropriate file type or formattar: Error exit delayed from previous errors.THis is very strange to me!The file I'm using came from source forge.Any hints about this installation is greatly appreciated.Don FoxP.S. The app that will using postgresql is written in python.
Don Fox <donfox1@mac.com> writes: > I'm downloading from Mac OS X Snow Leopard. This copy(from http://www.postgresql.org/ftp/source/v8.4.1/ > ) goes into my Downloads dir AND the Trash. > The file in the Trash still has the .zip extension while the one in > downloads has only the .tar. .zip? There are no .zip files at that webpage. What it sounds like is you've got Stuffit Expander or some similar utility configured to auto-expand compressed files, and it's messing the file up somehow. If it's a hangover from a former Leopard installation, maybe the problem is the utility isn't quite compatible with Snow Leopard. Another possibility is your browser is doing this. Check its preferences for something like "auto-open downloaded files". regards, tom lane
I ment .gz! Sorry!
On Oct 31, 2009, at 4:36 PM, Tom Lane wrote:
Don Fox <donfox1@mac.com> writes:I'm downloading from Mac OS X Snow Leopard. This copy(from http://www.postgresql.org/ftp/source/v8.4.1/) goes into my Downloads dir AND the Trash.The file in the Trash still has the .zip extension while the one indownloads has only the .tar.
.zip? There are no .zip files at that webpage.
What it sounds like is you've got Stuffit Expander or some similar
utility configured to auto-expand compressed files, and it's messing
the file up somehow. If it's a hangover from a former Leopard
installation, maybe the problem is the utility isn't quite compatible
with Snow Leopard.
Another possibility is your browser is doing this. Check its
preferences for something like "auto-open downloaded files".
regards, tom lane
The file you downloaded is probably corrupt. I am not a Mac expert but tar would have unpacked it if it was good.
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Don Fox
Sent: Friday, October 30, 2009 9:03 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Difficulty installing postgresql on Max OSX Leopard.
tar -zxvf postgresql-8.4.1.tar.gz
tar: Unrecognized archive format: Inappropriate file type or format
tar: Error exit delayed from previous errors.
THis is very strange to me!
The file I'm using came from source forge.
Any hints about this installation is greatly appreciated.
Don Fox
P.S. The app that will using postgresql is written in python.