[GRASSLIST:1396] postgreSQL problem

Hi GRASS users,
               I have downloaded the postgreSQL-7.3.4. I unzipped it and then went to the same dir of the postgresql and then installed it as follows:
1.) ./configure --prefix=/home/grass0pre3/psql --bindir=/home/grass0pre3/bin --without-readline
2.) gmake
3.) gmake check
4.) gmake install-all-headers
5.) gmake distclean

Then I wrote the following line in /etc/ldconfig "/home/grass0pre3/psql/lib" for the shared libraries.
Then I created a database and initialized it

root# mkdir /home/grass0pre3/psqldata
root# chown grass0pre3 /home/grass0pre3/psqldata
root# su grass0pre3
grass0pre3$ initdb -D /home/grass0pre3/psqldata

Lastly I started the server with

/home/grass0pre3/bin/postmaster -i -p 5432 -D /home/grass0pre3/psqldata >logfile 2>&1 &

Now when I run

createdb abc
and then
g.select.pg database=abc

I get the following error...

Error: select Postgres:could not connect to server: Connection refused
        Is the server running on host localhost and accepting
        TCP/IP connections on port 5432?

an any body tell me the problem and its related solution or have I missed anything during installation.

Thanks,

uttam.

_________________________________________________________________
Three simple steps. They guarantee your safety. http://server1.msn.co.in/features/general/SMBvirus/index.asp Protect yourself against the SMB.EXE virus.

* giovedì 02 ottobre 2003, alle 19:06, Uttam Kumar scrive:

Hi GRASS users,
              I have downloaded the postgreSQL-7.3.4. I unzipped it and
then went to the same dir of the postgresql and then installed it as
follows:
1.) ./configure --prefix=/home/grass0pre3/psql
--bindir=/home/grass0pre3/bin --without-readline
2.) gmake
3.) gmake check
4.) gmake install-all-headers
5.) gmake distclean

Then I wrote the following line in /etc/ldconfig
"/home/grass0pre3/psql/lib" for the shared libraries.
Then I created a database and initialized it

root# mkdir /home/grass0pre3/psqldata
root# chown grass0pre3 /home/grass0pre3/psqldata
root# su grass0pre3
grass0pre3$ initdb -D /home/grass0pre3/psqldata

Lastly I started the server with

/home/grass0pre3/bin/postmaster -i -p 5432 -D /home/grass0pre3/psqldata
>logfile 2>&1 &

Now when I run

createdb abc
and then
g.select.pg database=abc

I get the following error...

Error: select Postgres:could not connect to server: Connection refused
       Is the server running on host localhost and accepting
       TCP/IP connections on port 5432?

an any body tell me the problem and its related solution or have I missed
anything during installation.

It typically seems a problem concerning postgres not accepting
connections on the 5432 socket.
I suggest a few things:

a) go and set the tcpip_socket value to 1 (not 0) in the postgresql.conf
file (do a find to see where it is or try with "whereis
postgresql.conf";

b) edit the pg_hba.conf file (should be in the same dir) and make sure
you have something like this:

local all ident
sameuser
host all 127.0.0.1 255.0.0.0 ident
sameuser
host all 0.0.0.0 0.0.0.0 reject
host all 192.168.0.3 255.255.255.0 ident sameuser

in it.
It should do the game :slight_smile:

Bye

Dear GRASS Users

I downloaded some AVHRR files from <NOAA Satellite & Information>,
(some thing like this A3164585.L4908097).
For import these files into GRASS, I learned that < r.in.bin> can do this
work.
But I didn't find any infromation for <r.in.bin>s Parameteres
(north,south,east, west,r,c)
from my downloaded AVHRR files.

How could I import AVHRR into GRASS?

Eager for any help.
Heartfully Thanks.

Ghalip Yasin
Tsukuba University, Japan

I downloaded some AVHRR files from <NOAA Satellite & Information>,
(some thing like this A3164585.L4908097).

...

How could I import AVHRR into GRASS?

You might try r.in.gdal, see:

http://grass.ibiblio.org/gdp/html_grass5/html/r.in.gdal.html
http://www.remotesensing.org/gdal/frmt_l1b.html

Hamish

Dear Hamish,
Thank you too much.
I tried command r.in.gdal input=A3164585.L4908097 output=name, but it said:
ERROR4: 'A3164585.L4908097' not recognised as a supported file format.

[ I am using GRASS 5.0.2 (Aprial 2003). ]

Ghalip
  > I downloaded some AVHRR files from <NOAA Satellite & Information>,
  > (some thing like this A3164585.L4908097).
  > How could I import AVHRR into GRASS?

  You might try r.in.gdal, see:

On Sat, Oct 04, 2003 at 04:54:03PM +0900, Alip.Yasin wrote:

Thank you too much.
I tried command r.in.gdal input=A3164585.L4908097 output=name, but it said:
ERROR4: 'A3164585.L4908097' not recognised as a supported file format.

Looks like you have outdated GDAL. Please, run `gdalinfo --formats'
command and check whether the output contains a line for
`L1B: NOAA Polar Orbiter Level 1b Data Set'. If so and you still get an
error when reading your dataset, you should report this problem
via Bugzilla

http://bugzilla.remotesensing.org/enter_bug.cgi?product=GDAL

--
Andrey V. Kiselev
Home phone: +7 812 5274898 ICQ# 26871517

Hi all

I'm also working with AVHRR images but I'm importing
them in a different software because when I first
started working with them, GDAL would import but would
not do the automatic georreferencing. Does GDAL do
that now?

Thanks

Daniel
--- Andrey Kiselev <dron@ak4719.spb.edu> wrote:

On Sat, Oct 04, 2003 at 04:54:03PM +0900, Alip.Yasin
wrote:
> Thank you too much.
> I tried command r.in.gdal input=A3164585.L4908097
output=name, but it said:
> ERROR4: 'A3164585.L4908097' not recognised as a
supported file format.

Looks like you have outdated GDAL. Please, run
`gdalinfo --formats'
command and check whether the output contains a line
for
`L1B: NOAA Polar Orbiter Level 1b Data Set'. If so
and you still get an
error when reading your dataset, you should report
this problem
via Bugzilla

http://bugzilla.remotesensing.org/enter_bug.cgi?product=GDAL

--
Andrey V. Kiselev
Home phone: +7 812 5274898 ICQ# 26871517

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

On Sat, Oct 04, 2003 at 10:35:22AM -0700, Daniel Victoria wrote:

I'm also working with AVHRR images but I'm importing
them in a different software because when I first
started working with them, GDAL would import but would
not do the automatic georreferencing. Does GDAL do
that now?

GDAL can read control points stored in every AVHRR file and you can
georeference the image using them.

          Andrey

--
Andrey V. Kiselev
Home phone: +7 812 5274898 ICQ# 26871517

On Sat, Oct 04, 2003 at 09:50:21PM +0400, Andrey Kiselev wrote:

On Sat, Oct 04, 2003 at 10:35:22AM -0700, Daniel Victoria wrote:
> I'm also working with AVHRR images but I'm importing
> them in a different software because when I first
> started working with them, GDAL would import but would
> not do the automatic georreferencing. Does GDAL do
> that now?

GDAL can read control points stored in every AVHRR file and you can
georeference the image using them.

To my experience the polynomial rectification provided by GDAL is not
appropriate to achieve high precision geocoding (same as i.rectify).
I got shifts of up to 25km, implementation of local splines or similar
will be required (welcome also for i.rectify).

Markus

Dear Andrey Kiselev

I tried <gdalinfo --formats> and I have GDAL supported file name <L1B: NOAA
Polar Orbiter Level 1b Data Set> listed there.
But still r.in.gdal gives me "not supported file" error.
I will try to use Bugzilla to report this problem.

Thank you all for your help to me.
Thank you a lot.

Sincerely
Ghalip Yasin
Tsukuba University,Japan

  On Sat, Oct 04, 2003 at 04:54:03PM +0900, Alip.Yasin wrote:
  > Thank you too much.
  > I tried command r.in.gdal input=A3164585.L4908097 output=name, but it
said:
  > ERROR4: 'A3164585.L4908097' not recognised as a supported file format.

  Looks like you have outdated GDAL. Please, run `gdalinfo --formats'
  command and check whether the output contains a line for
  `L1B: NOAA Polar Orbiter Level 1b Data Set'. If so and you still get an
  error when reading your dataset, you should report this problem
  via Bugzilla

   http://bugzilla.remotesensing.org/enter_bug.cgi?product=GDAL

  --
  Andrey V. Kiselev
  Home phone: +7 812 5274898 ICQ# 26871517

On Mon, Oct 06, 2003 at 02:37:46AM +0900, Alip.Yasin wrote:

Dear Andrey Kiselev

I tried <gdalinfo --formats> and I have GDAL supported file name <L1B: NOAA
Polar Orbiter Level 1b Data Set> listed there.
But still r.in.gdal gives me "not supported file" error.
I will try to use Bugzilla to report this problem.

There is probably a local copy of libgdal within your GRASS installation
which is used by r.in.gdal instead of the system-wide installed library.

Markus

Thank you all for your help to me.
Thank you a lot.

Sincerely
Ghalip Yasin
Tsukuba University,Japan

  On Sat, Oct 04, 2003 at 04:54:03PM +0900, Alip.Yasin wrote:
  > Thank you too much.
  > I tried command r.in.gdal input=A3164585.L4908097 output=name, but it
said:
  > ERROR4: 'A3164585.L4908097' not recognised as a supported file format.

  Looks like you have outdated GDAL. Please, run `gdalinfo --formats'
  command and check whether the output contains a line for
  `L1B: NOAA Polar Orbiter Level 1b Data Set'. If so and you still get an
  error when reading your dataset, you should report this problem
  via Bugzilla

   http://bugzilla.remotesensing.org/enter_bug.cgi?product=GDAL

  --
  Andrey V. Kiselev
  Home phone: +7 812 5274898 ICQ# 26871517

Dear Mr.Markus Neteler

Thank you very much for your advice.
        >>There is probably a local copy of libgdal within your GRASS
installation
        >>which is used by r.in.gdal instead of the system-wide installed
library.
But sorry for my one after one foolish questions.
On this case, I don't know what I should do for solve this problem.
Could you please tell me further, how could I solve this problem?
Thank you, heartfully thank you for your patiently help.

Sincerely
Ghalip Yasin
Tsukuba University,Japan

On Tue, Oct 07, 2003 at 11:14:47PM +0900, Alip.Yasin wrote:

Dear Mr.Markus Neteler

Thank you very much for your advice.
        >>There is probably a local copy of libgdal within your GRASS
installation
        >>which is used by r.in.gdal instead of the system-wide installed
library.
But sorry for my one after one foolish questions.
On this case, I don't know what I should do for solve this problem.
Could you please tell me further, how could I solve this problem?
Thank you, heartfully thank you for your patiently help.

Check if
/usr/local/grass5/lib/
contains a libgdal. If libgdal in /usr/local/lib is more recent,
replace
/usr/local/grass5/lib/libgdal... by a link to /usr/local/lib/libgdal...

Regards

--
Markus Neteler <neteler@itc.it> http://mpa.itc.it
ITC-irst, Istituto per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18 - 38050 Povo (Trento), Italy