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
_______________________________________________
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
