postgresql91-server install

[Érico]

Hello

Thank you all for the help with mysql install and configuration

It is working now

I am jumping now to postgres which is the second db server I need to
configure

for that I have in my computer :

$ port installed
postgresql91 @9.1.1_1
postgresql91 @9.1.2_1 (active)
postgresql91-server @9.1.2_0 (active)
postgresql_select @0.1_0 (active)
readline @6.2.000_0 (active)

I ran :
1. sudo port load postgresql91-server

2. it does save in /Libraries/LaunchDeamons :
$ ls -la /Library/LaunchDaemons/
total 16
drwxr-xr-x   4 root  wheel   136 Jan 11 20:29 .
drwxrwxr-t+ 61 root  admin  2074 Jan  9 21:42 ..
-rw-r--r--   1 root  wheel   790 Jan  9 21:42
com.google.keystone.daemon.plist
lrwxr-xr-x   1 root  admin   100 Jan  8 19:35
org.macports.postgresql91-server.plist ->
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/org.macports.postgresql91-server.plist

3. I run :

4. it is like this after steps 1,2 and 3 :

bash-3.2# ps aux | grep 'postgres'
root       374   0.6  0.0  2435120    404 s001  R+    9:39PM   0:00.00 grep
postgres
postgres   308   0.0  0.0  2446484    416   ??  Ss    9:28PM   0:00.10
postgres: stats collector process
postgres   307   0.0  0.0  2486920   1580   ??  Ss    9:28PM   0:00.09
postgres: autovacuum launcher process
postgres   306   0.0  0.0  2486788    516   ??  Ss    9:28PM   0:00.11
postgres: wal writer process
postgres   305   0.0  0.0  2486788    784   ??  Ss    9:28PM   0:00.14
postgres: writer process
postgres   303   0.0  0.2  2486788   7052 s000  S     9:28PM   0:00.18
/opt/local/lib/postgresql91/bin/postgres -D
/opt/local/var/db/postgresql91/testdb
postgres   295   0.0  0.0  2435548   1008 s000  S+    9:28PM   0:00.06 bash
root       294   0.0  0.1  2467416   4016 s000  S     9:27PM   0:00.02 su
postgres
root       325   0.0  0.0  2455108   1044   ??  Ss    9:31PM   0:00.01
/opt/local/bin/daemondo --label=postgresql91-server --start-cmd
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapper
start ; --stop-cmd
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapper
stop ; --restart-cmd
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapper
restart ; --pid=none


5. sudo mkdir -p /opt/local/var/db/postgresql91/testdb


6. sudo chown postgres:postgres /opt/local/var/db/postgresql91/testdb


7. sudo su postgres -c '/opt/local/lib/postgresql91/bin/initdb -D
/opt/local/var/db/postgresql91/testdb'

bash-3.2# sudo su postgres -c '/opt/local/lib/postgresql91/bin/initdb -D
/opt/local/var/db/postgresql91/testdb'
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
....
Success. You can now start the database server using:

    /opt/local/lib/postgresql91/bin/postgres -D
/opt/local/var/db/postgresql91/testdb
or
    /opt/local/lib/postgresql91/bin/pg_ctl -D
/opt/local/var/db/postgresql91/testdb -l logfile start
....


8. in a second terminal as postgres id :

bash-3.2$ /opt/local/lib/postgresql91/bin/pg_ctl -D
/opt/local/var/db/postgresql91/testdb -l /opt/apache/db/logfile start
server starting
...

9. then in the same terminal as  postgres id :
bash-3.2$ psql -d testdb
psql: FATAL:  could not open relation mapping file
"global/pg_filenode.map": No such file or directory

10. in log file I have several lines with this content :
LOG:  could not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No
such file or directory



Can you guys help us out on this one too please ?

Regards
Érico
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20120111/63c3c2b5/attachment.html>