{"id":21,"date":"2013-02-28T14:53:00","date_gmt":"2013-02-28T14:53:00","guid":{"rendered":""},"modified":"2021-08-31T10:12:45","modified_gmt":"2021-08-31T09:12:45","slug":"creating-and-running-postgresql-on-mac","status":"publish","type":"post","link":"https:\/\/www.srivittal.com\/wp\/?p=21","title":{"rendered":"Creating and running Postgresql on mac"},"content":{"rendered":"
I am using macports for the installation<\/p>\n

Run<\/p>\n

sudo port install postgresql92<\/span><\/span><\/p>\n

and then<\/p>\n

sudo port install postgresql92-server<\/span><\/span><\/p>\n

Once the server has been installed, run the following<\/p>\n

To create a database instance, after install do<\/p>\n

 sudo mkdir -p \/opt\/local\/var\/db\/postgresql92\/defaultdb
 sudo chown postgres:postgres \/opt\/local\/var\/db\/postgresql92\/defaultdb
 sudo su postgres -c ‘\/opt\/local\/lib\/postgresql92\/bin\/initdb -D \/opt\/local\/var\/db\/postgresql92\/defaultdb’<\/span><\/span><\/p>\n

The output you will see<\/p>\n

The files belonging to this database system will be owned by user “postgres”.
This user must also own the server process.<\/p>\n

The database cluster will be initialized with locale “en_GB.utf-8”.
The default database encoding has accordingly been set to “UTF8”.
The default text search configuration will be set to “english”.<\/p>\n

fixing permissions on existing directory \/opt\/local\/var\/db\/postgresql92\/defaultdb … ok
creating subdirectories … ok
selecting default max_connections … 20
selecting default shared_buffers … 1600kB
creating configuration files … ok
creating template1 database in \/opt\/local\/var\/db\/postgresql92\/defaultdb\/base\/1 … ok
initializing pg_authid … ok
initializing dependencies … ok
creating system views … ok
loading system objects’ descriptions … ok
creating collations … ok
creating conversions … ok
creating dictionaries … ok
setting privileges on built-in objects … ok
creating information schema … ok
loading PL\/pgSQL server-side language … ok
vacuuming database template1 … ok
copying template1 to template0 … ok
copying template1 to postgres … ok<\/p>\n

WARNING: enabling “trust” authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
–auth-local and –auth-host, the next time you run initdb.<\/p>\n

Success. You can now start the database server using:<\/p>\n

    \/opt\/local\/lib\/postgresql92\/bin\/postgres -D \/opt\/local\/var\/db\/postgresql92\/defaultdb
or
    \/opt\/local\/lib\/postgresql92\/bin\/pg_ctl -D \/opt\/local\/var\/db\/postgresql92\/defaultdb -l logfile start<\/span><\/span><\/p>\n

Switch to the postgres id using<\/p>\n

sudo su – postgres<\/span><\/span><\/p>\n

Then run the following command<\/p>\n

\/opt\/local\/lib\/postgresql92\/bin\/postgres -D \/opt\/local\/var\/db\/postgresql92\/defaultdb<\/span><\/span><\/p>\n

The output will be<\/p>\n

LOG:  database system was shut down at 2013-02-28 14:43:36 GMT
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started <\/span><\/span><\/p>\n

Once you run the above command as suggested, the server will be available for use<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

I am using macports for the installation Run sudo port install postgresql92 and then sudo port install postgresql92-server Once the server has been installed, run the following To create a database instance, after install do  sudo mkdir -p \/opt\/local\/var\/db\/postgresql92\/defaultdb sudo chown postgres:postgres \/opt\/local\/var\/db\/postgresql92\/defaultdb sudo su postgres -c ‘\/opt\/local\/lib\/postgresql92\/bin\/initdb -D \/opt\/local\/var\/db\/postgresql92\/defaultdb’ The output you will see The files …<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,26,27,28],"tags":[],"class_list":["post-21","post","type-post","status-publish","format-standard","hentry","category-installation","category-mac-osx","category-macports","category-postgres-sql","entry entry-center"],"_links":{"self":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/21","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21"}],"version-history":[{"count":1,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":112,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions\/112"}],"wp:attachment":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}