Postgresql: Difference between revisions
From DWIKI
No edit summary |
|||
| Line 8: | Line 8: | ||
*http://www.freebsddiary.org/postgresql.php (doesn't seem entirely right) | *http://www.freebsddiary.org/postgresql.php (doesn't seem entirely right) | ||
(pg_ctl: could not read file "/usr/local/pgsql/data/postmaster.opts") : | |||
After installing and creating db: | After installing and creating db: | ||
As user pgsql | As user pgsql | ||
| Line 15: | Line 17: | ||
Ater which it should be possible to run ( as root again) | Ater which it should be possible to run ( as root again) | ||
/usr/local/etc/rc.d/postgresql start | /usr/local/etc/rc.d/postgresql start | ||
=FAQ= | =FAQ= | ||
Revision as of 09:31, 3 March 2009
Links
Installation
Postgresql on freebsd
- http://www.freebsddiary.org/postgresql.php (doesn't seem entirely right)
(pg_ctl: could not read file "/usr/local/pgsql/data/postmaster.opts") :
After installing and creating db:
As user pgsql
/usr/local/bin/postmaster -D /usr/local/pgsql/data pg_ctl stop
Ater which it should be possible to run ( as root again)
/usr/local/etc/rc.d/postgresql start
FAQ
Create user
su - postgres createuser
