Thread: run postgresql

i've been trying install postgresql9.0.4 on ubuntu 11.04. first took source code here , extracted /home/user/postgresql-9.0.4. closely following labyrinthine user manual, compliant windows user am, performed ./configure, ./make, install, set ld_library_path /usr/local/pgsql/lib , path /usr/local/pgsql/bin:$path.

still not sure / why doing (apart being written in online tutorials), added linux user mycat, swtiched postgres unix user "su - postgres" , tried connect db server "psql template1". got message: "psql: not connect server: no such file or directory
is server running locally , accepting
connections on unix domain socket "/tmp/.s.pgsql.5432"?
", can't answer on own.

anyway, here output of " ps auxw | grep post", think means postgresql run on system.

postgres 1030 0.0 0.1 105448 6728 ? s 16:07 0:00 /usr/lib/postgresql/8.4/bin/postgres -d /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf
postgres 1177 0.0 0.0 105448 1664 ? ss 16:07 0:00 postgres: writer process
postgres 1178 0.0 0.0 105448 1424 ? ss 16:07 0:00 postgres: wal writer process
postgres 1179 0.0 0.0 105580 1824 ? ss 16:07 0:00 postgres: autovacuum launcher process
postgres 1180 0.0 0.0 77000 1516 ? ss 16:07 0:00 postgres: stats collector process
postgres 2081 0.0 0.0 104716 3964 pts/0 s 16:24 0:00 su - postgres
postgres 2089 0.0 0.2 30696 8156 pts/0 s 16:24 0:00 -su
postgres 2218 0.0 0.0 21932 1388 pts/0 r+ 16:31 0:00 ps auxw
postgres 2219 0.0 0.0 13128 1060 pts/0 s+ 16:31 0:00 grep --color=auto post


wanna (actually need do) create db , use it. how can accomplish this?

thank u

just use package manager install postgresql on ubuntu, e.g., sudo apt-get install postgresql

tim

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support New to Ubuntu [lubuntu] run postgresql

Ubuntu