Skip site navigation (1) Skip section navigation (2)

Install problems for postgresql-8.4.1

From: Don Fox <donfox1(at)mac(dot)com>
To: "Mark H(dot) Nichols" <info(at)markhnichols(dot)com>, pgsql-novice(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Install problems for postgresql-8.4.1
Date: 2009-11-01 17:18:42
Message-ID: 5321FE54-6B6D-4A61-90D4-B2ED0E369677@mac.com (view raw or flat)
Thread:
Lists: pgsql-novice
Here is record of my attempt to do the install! I've used several sets  
of instructions for installing from src,  mainly  http://zanshin.net/2009/09/07/installing-postgresql-on-mac-10-6-snow-leopard/ 
  which appears to be the clearest.

Obviously something has been omitted! Any suggestions are greatly  
appreciated.

This installation will be used with python and an opens source  
application 'GNUmed' used for electronic medical records.

Thanks,

Don


./configure --with-perl --with-python --with-openssl --with-bonjour  
PERL=/usr/bin/perl PYTHON=/usr/bin/python
  make
  sudo make install

Resulted with apparent success

PostgreSQL installation complete.

This is in .profile

if [ -d /usr/local/pgsql/bin ] ; then
      PATH="/usr/local/pgsql/bin:${PATH}"
fi
export PATH

I'm using 103

sudo dseditgroup -o create -i 102 -r "PostgreSQL Users" postgres

Shouldn't the following result in a postgres file under /Users?
It doesn't!

sudo dscl . -create /Users/postgres
sudo dscl . -create /Users/postgres UniqueID 102
sudo dscl . -create /Users/postgres UserShell /bin/bash
sudo dscl . -create /Users/postgres RealName "Postgres Administrator"
sudo dscl . -create /Users/postgres NFSHomeDirectory /usr/local/pgsql
sudo dscl . -create /Users/postgres PrimaryGroupID 102
sudo dscl . -create /Users/postgres Password postgres
sudo chown -R postgres:postgres /usr/local/pgsql

Then did this and went tosystem prefs pane and reset Accounts for  
Postgres Admin to 'postgres'.

cd /usr/local/
...:local donfox1$ su postgres
Password:
bash-3.2$ whoami
postgres

bash-3.2$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user  
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

creating directory /usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

     /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
or
     /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile  
start

bash-3.2$

bash-3.2$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l  
logfile.log start
server starting
bash-3.2$ sh: logfile.log: Permission denied

But this works!

bash-3.2$ pg_ctl -D /usr/local/pgsql/data status
pg_ctl: server is running (PID: 60134)
/usr/local/pgsql/bin/postgres "-D" "/usr/local/pgsql/data"
bash-3.2$


bash-3.2$  pg_ctl -D /usr/local/pgsql/data start  &
[1] 60129
bash-3.2$ server starting
LOG:  database system was shut down at 2009-11-01 11:49:21 EST
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections


However!
bash-3.2$ createdb testdb
Bus error


sh-3.2# ls -l
total 0
drwxr-xr-x  23 postgres  postgres   782 Nov  1 00:15 bin
drwx------  15 postgres  postgres   510 Nov  1 00:31 data
drwxr-xr-x  24 postgres  postgres   816 Nov  1 00:15 include
drwxr-xr-x  50 postgres  postgres  1700 Nov  1 00:15 lib
drwxr-xr-x  21 postgres  postgres   714 Nov  1 00:15 share


Responses

pgsql-novice by date

Next:From: Mark H. NicholsDate: 2009-11-01 20:00:27
Subject: Re: Install problems for postgresql-8.4.1
Previous:From: Tom LaneDate: 2009-11-01 15:37:11
Subject: Re: Apple switched to BSDtar from GNUtar with Leopard

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group