![]() ![]() Or, if you don't want/need a background service you can just run: To have launchd start postgresql now and restart at login: => /usr/local/Cellar/postgresql/9.6.5/bin/initdb /usr/local/var/postgres So the "correct way" to get the psql application is indeed to install the postgres formula, and you'll see toward the bottom of the "caveats" section that it doesn't actually run the database, it just puts the files on your system: $ brew install postgres You can always re-create the data-directory, but be sure to make a backup and do not overwrite it when postgres is still running.Homebrew only really has the postgres formula, and doesn't have any specific formula that only installs the psql tool. It's important to sudo as the postgres user here, because the user-account the postgres deamons runs as will have to have the sufficients access-rights.Īlso, you will have to start the deamon with the the sudo (this should later be handled by a lauchctl-entry, or something similar), so: sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /Library/PostgreSQL/8.4/data nf, a bunch of pg_* and some other files, all belonging to postgres, the data directory seems to be allright, otherwise invoke the following (replace the binary-path, postgres-user and the data path with your system-values, see man initdb for more options): sudo -u postgres /usr/local/pgsql/bin/initdb -D /Library/PostgreSQL/8.4/data Look inside this directory (you may need to su/sudo because you may not have sufficient privileges to do so with your console user). ![]() I guess Fink has already created it, so check out the install-logs. This directory should belong already to the postgres-user and have rwx-privileges for him. ![]() Your error messages seems to say this may be "/Library/PostgreSQL/8.4/data". ![]() I don't know the fink-properties for PostgreSQL, but the associated daemons are supposed to run under a dedicated user-account (lets say postgres for example).įirst identify the data-directory, in which PostgresSQL stores it's data and configuration files exist. It seems to me, you're trying to run PostgresSQL under your current user-account. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |