>
>> Is the server running locally and accepting
>> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>>
>>What should be done else ?
>>
>>
>>
>
>If you reinstall postgres from source you have to manually rebuild the database directory, user, etc..
>
>
>You have to follow carefully this instructions:
>
>http://www.postgresql.org/docs/7.4/static/creating-cluster.html
>http://www.postgresql.org/docs/7.4/static/postmaster-start.html
>
>
>you will also have to create a new database user and remember to use the database administrator user (eg postgres)
>
>postgres$ initdb -D /usr/local/pgsql/data
>^^^^^^^^
>
>to do administration task like starting and stopping the postmaster.
>
>Michele.
>
>
>
thank you
I can run new postgresql alone using postmaster and psql.
But grass cannot connect to new postgre, although I have
recompiled grass with new path of postgresql.
Ahmet
Ahmet,
If you followed the manpages above and you still have problems, please be more specific about the steps you followed and error messages...
Michele.
____________________________________________________________
Libero Flat, sempre a 4 Mega a 19,95 euro al mese!
Abbonati subito su http://www.libero.it
Michele wrote:
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
What should be done else ?
If you reinstall postgres from source you have to manually rebuild the database directory, user, etc..
You have to follow carefully this instructions:
http://www.postgresql.org/docs/7.4/static/creating-cluster.html
http://www.postgresql.org/docs/7.4/static/postmaster-start.html
you will also have to create a new database user and remember to use the database administrator user (eg postgres)
postgres$ initdb -D /usr/local/pgsql/data
^^^^^^^^
to do administration task like starting and stopping the postmaster.
Michele.
thank you
I can run new postgresql alone using postmaster and psql.
But grass cannot connect to new postgre, although I have
recompiled grass with new path of postgresql.
Ahmet
Ahmet,
If you followed the manpages above and you still have problems, please be more specific about the steps you followed and error messages...
Michele.
____________________________________________________________
Libero Flat, sempre a 4 Mega a 19,95 euro al mese! Abbonati subito su http://www.libero.it
thank you again
I reviewed the man pages.
But the problem goes on:
(before I realized your mail, I had sent a new mail)
I have no problem connecting to the database without grass:
postmaster and psql works seems to work properly.
$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -p 5432
LOG: database system was shut down at 2005-08-29 14:23:59 EEST
LOG: checkpoint record is at 0/12C5AC04
LOG: redo record is at 0/12C5AC04; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 5175; next OID: 3851158
LOG: database system is ready
I can enter the database with :
psql sil
~~~~~~~~
But:
connection from grass to postgresql fails:
db.tables driver=pg database=sil
DBMI-Postgres driver error:
Cannot connect to 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"?
how can I solve the problem ?
Ahmet
______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.
Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.
On Mon, Aug 29, 2005 at 02:51:37PM +0300, orkun wrote:
Michele wrote:
>>>> Is the server running locally and accepting
>>>> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>>>>
>>>>What should be done else ?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>If you reinstall postgres from source you have to manually rebuild the
>>>database directory, user, etc..
>>>
>>>
>>>You have to follow carefully this instructions:
>>>
>>>http://www.postgresql.org/docs/7.4/static/creating-cluster.html
>>>http://www.postgresql.org/docs/7.4/static/postmaster-start.html
>>>
>>>
>>>you will also have to create a new database user and remember to use the
>>>database administrator user (eg postgres)
>>>
>>>postgres$ initdb -D /usr/local/pgsql/data
>>>^^^^^^^^
>>>
>>>to do administration task like starting and stopping the postmaster.
>>>
>>>Michele.
>>>
>>>
>>>
>>>
>>>
>>thank you
>>
>>I can run new postgresql alone using postmaster and psql.
>>But grass cannot connect to new postgre, although I have
>>recompiled grass with new path of postgresql.
>>
>>
>>Ahmet
>>
>>
>
>Ahmet,
>
>If you followed the manpages above and you still have problems, please be
>more specific about the steps you followed and error messages...
>
>Michele.
>
>
>
>
>____________________________________________________________
>Libero Flat, sempre a 4 Mega a 19,95 euro al mese!
>Abbonati subito su http://www.libero.it
>
>
>
>
>
>
>
>
thank you again
I reviewed the man pages.
But the problem goes on:
(before I realized your mail, I had sent a new mail)
I have no problem connecting to the database without grass:
postmaster and psql works seems to work properly.
$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -p 5432
There is no -i flag which means that Postgresql doesn't work in
TCP/IP mode. This can be enabled in postgresql.conf
Markus
Markus Neteler wrote:
On Mon, Aug 29, 2005 at 02:51:37PM +0300, orkun wrote:
Michele wrote:
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
What should be done else ?
If you reinstall postgres from source you have to manually rebuild the database directory, user, etc..
You have to follow carefully this instructions:
http://www.postgresql.org/docs/7.4/static/creating-cluster.html
http://www.postgresql.org/docs/7.4/static/postmaster-start.html
you will also have to create a new database user and remember to use the database administrator user (eg postgres)
postgres$ initdb -D /usr/local/pgsql/data
^^^^^^^^
to do administration task like starting and stopping the postmaster.
Michele.
thank you
I can run new postgresql alone using postmaster and psql.
But grass cannot connect to new postgre, although I have
recompiled grass with new path of postgresql.
Ahmet
Ahmet,
If you followed the manpages above and you still have problems, please be more specific about the steps you followed and error messages...
Michele.
____________________________________________________________
Libero Flat, sempre a 4 Mega a 19,95 euro al mese! Abbonati subito su http://www.libero.it
thank you again
I reviewed the man pages.
But the problem goes on:
(before I realized your mail, I had sent a new mail)
I have no problem connecting to the database without grass:
postmaster and psql works seems to work properly.
$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -p 5432
There is no -i flag which means that Postgresql doesn't work in
TCP/IP mode. This can be enabled in postgresql.conf
Markus
thank you markus,
when I start postmaster with the port which grass is listening postgre db from
grass works on postgredb.
postgres@landslide:/home/orkun$ /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data/ -k /var/ run/postgresql/
grass uses this port (/var/ run/postgresql/)
** how can I make grass listen postgresql from /tmp/.s.PGSQL.5432 ?
because at the same time I want to work on same db out of grass
with psql, but it gives:
postgres@landslide:/home/orkun$ /usr/local/pgsql/bin/psql bzk
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
kind regards
Ahmet
______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.
Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.
orkun wrote:
Markus Neteler wrote:
On Mon, Aug 29, 2005 at 02:51:37PM +0300, orkun wrote:
Michele wrote:
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
What should be done else ?
If you reinstall postgres from source you have to manually rebuild the database directory, user, etc..
You have to follow carefully this instructions:
http://www.postgresql.org/docs/7.4/static/creating-cluster.html
http://www.postgresql.org/docs/7.4/static/postmaster-start.html
you will also have to create a new database user and remember to use the database administrator user (eg postgres)
postgres$ initdb -D /usr/local/pgsql/data
^^^^^^^^
to do administration task like starting and stopping the postmaster.
Michele.
thank you
I can run new postgresql alone using postmaster and psql.
But grass cannot connect to new postgre, although I have
recompiled grass with new path of postgresql.
Ahmet
Ahmet,
If you followed the manpages above and you still have problems, please be more specific about the steps you followed and error messages...
Michele.
____________________________________________________________
Libero Flat, sempre a 4 Mega a 19,95 euro al mese! Abbonati subito su http://www.libero.it
thank you again
I reviewed the man pages.
But the problem goes on:
(before I realized your mail, I had sent a new mail)
I have no problem connecting to the database without grass:
postmaster and psql works seems to work properly.
$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -p 5432
There is no -i flag which means that Postgresql doesn't work in
TCP/IP mode. This can be enabled in postgresql.conf
Markus
thank you markus,
when I start postmaster with the port which grass is listening postgre db from
grass works on postgredb.
postgres@landslide:/home/orkun$ /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data/ -k /var/ run/postgresql/
grass uses this port (/var/ run/postgresql/)
** how can I make grass listen postgresql from /tmp/.s.PGSQL.5432 ?
because at the same time I want to work on same db out of grass
with psql, but it gives:
postgres@landslide:/home/orkun$ /usr/local/pgsql/bin/psql bzk
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
kind regards
Ahmet
______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.
Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.
hello
sorry for multiple mails
I found a answer to my last question.
using an soft link, I can listen postgredb at the same time with grass and psql
is there any better way ?
regards
Ahmet
______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster@deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.
Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.