[postgis-users] pgsql2shp

Elstermann, Mike Mike.Elstermann at itc-halle.de
Tue Jul 8 02:35:14 PDT 2003


if have an tcp/ip-problem

	postgres at susi:/usr/local/pgsql/bin> pgsql2shp gisdb alk_fo
	Connection to database 'gisdb' failed.
	could not connect to server: Connection refused
      	  Is the server running on host localhost and accepting
	        TCP/IP connections on port 5432?
	postgres at susi:/usr/local/pgsql/bin>

how can i start postmaster with i-option
	---- output for help --------------
	postgres at susi:/usr/local/pgsql/bin> pg_ctl --help
	pg_ctl is a utility to start, stop, restart, reload configuration
files,
	or report the status of a PostgreSQL server.

	Usage:
	  pg_ctl start   [-w] [-D DATADIR] [-s] [-l FILENAME] [-o "OPTIONS"]
	  pg_ctl stop    [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
	  pg_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o
"OPTIONS"]
	  pg_ctl reload  [-D DATADIR] [-s]
	  pg_ctl status  [-D DATADIR]
	
	Common options:
	  -D DATADIR   location of the database storage area
	  -s 	         only print errors, no informational messages
	  -w           wait until operation completes
	  -W           do not wait until operation completes
	  --help       show this help, then exit
	  --version    output version information, then exit
	(The default is to wait for shutdown, but not for start or restart.)
	
	If the -D option is omitted, the environment variable PGDATA is
used.
	
	Options for start or restart:
	  -l FILENAME             write (or append) server log to FILENAME.
The
	                          use of this option is highly recommended.
	  -o OPTIONS              command line options to pass to the
postmaster
	     	                    (PostgreSQL server executable)
	  -p PATH-TO-POSTMASTER   normally not necessary

	Options for stop or restart:
	  -m SHUTDOWN-MODE   may be 'smart', 'fast', or 'immediate'

	Shutdown modes are:
	  smart       quit after all clients have disconnected
	  fast        quit directly, with proper shutdown
	  immediate   quit without complete shutdown; will lead to recovery
on restart

Report bugs to <pgsql-bugs at postgresql.org>.
postgres at susi:/usr/local/pgsql/bin>

an which values must i insert in the "pg_hba.conf" and the "postmaster.conf"

::: mfg. Mike Elstermann [mikeE.], Teamleiter GIS/RIS, e-Solutions
::: IT-Consult Halle GmbH, Bornknechtstraße 5, 06108 Halle (Saale)
::: Sitz: Rathausstraße 3
::: Tel.: +49 345 221 4237, Fax: +49 345 221 4236, mobil: +49 160 71 545 02
::: mike.elstermann at itc-halle.de ::: http://www.itc-halle.de
::: GeoDaten Online? -> http://www.itcgis.de



More information about the postgis-users mailing list