[postgis-users] pgsql2shp
Benjamin Wragg
bwragg at tpg.com.au
Wed Jul 9 16:49:59 PDT 2003
If you use the pg_ctl command it is
pg_ctl -D /path/to/data -o "-i" start
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina DND\MIS
Sent: Tuesday, 8 July 2003 10:39 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] pgsql2shp
postmaster -D /usr/share/postgresql/data -i &
where -D ....data is the path to the postgresql initialized data store.
-----Original Message-----
From: Elstermann, Mike [mailto:Mike.Elstermann at itc-halle.de]
Sent: Tuesday, July 08, 2003 5:35 AM
To: 'postgis-users at postgis.refractions.net'
Cc: 'staub at gik.uni-karlsruhe.de'
Subject: [postgis-users] pgsql2shp
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
_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list