postgresql.1.txt
author viric@mandarina
Thu, 15 May 2008 19:00:38 +0200
changeset 1 840aebd2e31e
parent 0 c66307cca740
permissions -rw-r--r--
New pages
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     1
Set your database path:
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     2
  export PGDATA=/tmp/mydata
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     3
Init the database:
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     4
  initdb
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     5
Start the server:
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     6
  postgres
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     7
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     8
Create a database:
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
     9
  createdb <dbname>
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
    10
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
    11
Access it:
c66307cca740 Initial.
viric@llimona
parents:
diff changeset
    12
  psql <dbname>