postgsql on ubuntu 8.10 intrepid ibex

[jpdpoker]

HI I installed postgsql on ubuntu 8.10 intrepid ibex and typed comand to start making a new Dbase but stoped as I had to do somthing else to do and had no time.

Next time I went back and tried again II just get errors.

I tried typing in psql but only get these errors

jpd@jpd-desktop:~$ sudo su postgres
postgres@jpd-desktop:/home/jpd$ createuser -U postgres --createdb --no-adduser -P terp
Enter password for new role:
Enter it again:
Shall the new role be allowed to create more new roles? (y/n) y
createuser: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
postgres@jpd-desktop:/home/jpd$ createdb -U postgres -O terp --encoding=UNICODE terp
createdb: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
postgres@jpd-desktop:/home/jpd$ gedit /etc/default/tinyerp-server
No protocol specified

(gedit:7992): Gtk-WARNING **: cannot open display: :0.0

I don't know what to do next?

[kraada]

Run: ps auxw | grep -i postgres to make sure that postgres is currently running on the machine; more than likely it isn't.

To start it up, run sudo /etc/init.d/postgresql-8.3 start
and it should start the server up.

[jpdpoker]

jpd@jpd-desktop:~$ run sudo /etc/init.d/postgresql-8.3 start
bash: run: command not found

If I try to run postgresql it asks for pass word but I thought I knew it but it dosn't work

Any way of changing it short of uninstalling it?

[kraada]

The command you want is just:
sudo /etc/init.d/postgresql-8.3 start

You will need to put in a password, that is the same user password you use to log into your machine, and then it should start up properly.

[jpdpoker]

HI Is it possible to import a poker tracker 3 Dbase from windows to linux?

If so how?

[WhiteRider]

You will need to backup your database and then restore it on your linux box.
Please see the Database / Postgres FAQ

[jpdpoker]

I think u can mark this post solved!

I managed to import all my data base into linux from windwos xp pro.

I havn't run a game yet but poker tracker runs on my VM's and can access my data etc.!

Many thanks to all posters!!!

[kraada]

You're welcome; I'm glad we got things working for you