PostgreSQL on Koala

[Rayson]

I really like Koala however I have never been successful installing PostgreSQL 8.4. Has anyone made this work on Koala that would be willing to help?

I am running on a 64 bit OS and have the following installed:

postgresql-doc – 8.4.1-1
postgresql-client – 8.4.1-1
postgresql-8.4 – 8.4.1-1 (amd64)
postgresql-8.4 – 8.4.1-1 (amd64)
postgresql-contrib-8.4 (64bit)
pgadmin3 (64bit)
pgadmin3-data[/list]


I am not able to make a connection to the server useing the pgadmin interface (or from the command line for that matter). Once I get that far, I need to make a database.

Thanks,

Ray

[blobfish]

Re: PostgreSQL on Koala

I am running postgresql 8.4 on koala 32bit.
is the server running?
from terminal see if the server restarts.
sudo /etc/init.d/postgresql-8.4 restart

[Rayson]

Re: PostgreSQL on Koala

yes, the server is running and I can restart it from the command line.

Ray

[blobfish]

Re: PostgreSQL on Koala

did you try to set the root password? if not try this at the terminal.
sudo su postgres -c psql
ALTER USER postgres WITH PASSWORD 'password';

[Rayson]

Re: PostgreSQL on Koala

I have used the

ray@HPLaptopKoala:~$ sudo su postgres -c psql template1
[sudo] password for ray:
psql (8.4.1)
Type "help" for help.

postgres=# template1=# ALTER USER postgres WITH PASSWORD 'postgrespassword'
postgres-# template1=# \q

however if I use sudo su postgres -c psql and supply my linux root password then I get a
psql: FATAL: password authentication failed for user "postgres"

I don't get a chance to add your second line ie. >>> ALTER USER postgres WITH PASSWORD 'password';

What am I doing wrong?

Thanks,

Ray

[blobfish]

Re: PostgreSQL on Koala

I have setup the postgres password in the past as you describe, so I think you are ok. back at the terminal, try

psql -h localhost -d postgres -U postgres -W
postgrespassword

[Rayson]

Re: PostgreSQL on Koala

After copying in psql -h localhost -d postgres -U postgres -W
and entering what I believe is my password, I get:
psql: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "postgres", SSL on
FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "postgres", SSL of

I will go through the procedure of setting a postgres password as I outlined previously, then try this again. One thing I am not sure of is should be single quotes around the password that I want to use. Do you have an idea about that? ie. postgres WITH PASSWORD 'postgrespassword'

Thanks for helping on this.

Ray

[blobfish]

Re: PostgreSQL on Koala

yes it should be single quotes around your new password. Not sure what is going on. I would purge and reinstall the server and after the installation try this.

sudo su postgres -c psql
ALTER USER postgres WITH PASSWORD 'password';
\q

then you should be able to log back in with this.
psql -h localhost -d postgres -U postgres -W
password

[Rayson]

Re: PostgreSQL on Koala

OK - we are making progress!

I found that I needed to change a line in the pg_hba.conf file as follows:
local all all trust
Then I could reset the password. I noted the single quotes as you suggest. Then I could use the pgAdmin III to add a server and eventually make a database.

I noted that if I did a sudo psql -h localhost -d postgres -U postgres -W
and then put in my new password, I would get a:
psql: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "postgres", SSL on
FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "postgres", SSL off

So now I am going to try to move to the next step of installing SQL-Ledger (an accounting package).

Thanks much for your help,

Ray

[GreyGeek]

Re: PostgreSQL on Koala

This method still works: http://hocuspokus.net/2008/05/instal...-on-ubuntu-804