From LedHed's Wiki
(Created page with ' == FreeBSD == pkg_add -r postgresql82-server The package creates a 'pgsql' user account. Change to that user to finish the installation: su -m pgsql Initialise the database:...') |
(→FreeBSD) |
||
Line 7: | Line 7: | ||
su -m pgsql | su -m pgsql | ||
− | + | Initialize the database: | |
/usr/local/bin/initdb /usr/local/pgsql/data | /usr/local/bin/initdb /usr/local/pgsql/data | ||
Line 20: | Line 20: | ||
At this point the PostgreSQL daemon can be started. | At this point the PostgreSQL daemon can be started. | ||
/usr/local/etc/rc.d/postgresql start | /usr/local/etc/rc.d/postgresql start | ||
− | |||
== References == | == References == |
Revision as of 08:13, 4 June 2009
FreeBSD
pkg_add -r postgresql82-server
The package creates a 'pgsql' user account. Change to that user to finish the installation:
su -m pgsql
Initialize the database:
/usr/local/bin/initdb /usr/local/pgsql/data
Create a user:
/usr/local/bin/createuser USERNAME
Log out of the 'pgsql' user account by pressing
[CRTL]+d
or
lo
At this point the PostgreSQL daemon can be started.
/usr/local/etc/rc.d/postgresql start