[postgis-users] How to start the postgres service without root privilege

Tiger Wings tigerwings at gmail.com
Wed Mar 23 09:06:14 PST 2005


just a stupid error.
my geos and proj library files are not included.
Thank you very much,

T. W.
On Wed, 23 Mar 2005 08:11:21 +0100, strk at refractions.net
<strk at refractions.net> wrote:
> On Wed, Mar 23, 2005 at 12:38:35AM -0600, Tiger Wings wrote:
> > I fixed it.
> > Thank you very much!
> 
> Would you share the solution with us ? :)
> --strk;
> 
> >
> >
> > T.W.
> >
> >
> >
> > On Wed, 23 Mar 2005 07:03:14 +0100, strk at refractions.net
> > <strk at refractions.net> wrote:
> > > On Tue, Mar 22, 2005 at 03:11:13PM -0600, Tiger Wings wrote:
> > > > Yes, I did.
> > > >
> > > > 1) createdb ogc
> > > > -- -correct here
> > > > 2) createlang plpgsql ogc
> > > > -- -correct here
> > > > 3) psql ogc < ../../lwpostgis.sql > log
> > > > -- -error happened.
> > > > -- - in log file, it only says
> > > > -- - BEGIN
> > > > -- - ROLLBACK
> > > > -- - on terminal, it shows:
> > > > -- - ERROR:  current transaction is aborted, commands ignored until
> > > > end of transaction block
> > >
> > > Redirect stderr to a file also:
> > > $HOME/.../psql -f ../../lwpostgis.sql ogc > log 2>&1
> > >
> > > Only first error line shows the error, and using -f
> > > will include line number in error line.
> > >
> > > --strk;
> > >
> > > >
> > > > Thank you.
> > > >
> > > > T. W.
> > > >
> > > > On Tue, 22 Mar 2005 21:46:19 +0100, strk at refractions.net
> > > > <strk at refractions.net> wrote:
> > > > > On Tue, Mar 22, 2005 at 02:08:58PM -0600, Tiger Wings wrote:
> > > > > > I got it. Thank you.
> > > > > > One more question:
> > > > > > I tried to test the /examples/ogc_test_suite
> > > > > > after I run: psql ogc_test_suite < ../../lwpostgis.sql
> > > > > > an error occurs:
> > > > > > ERROR:  current transaction is aborted, commands ignored until end of
> > > > > > transaction block
> > > > >
> > > > > Did you read the README there?
> > > > > --strk;
> > > > >
> > > > > >
> > > > > > Many thanks.
> > > > > >
> > > > > > T. W.
> > > > > >
> > > > > > On Tue, 22 Mar 2005 18:55:15 +0100, strk at refractions.net
> > > > > > <strk at refractions.net> wrote:
> > > > > > > On Tue, Mar 22, 2005 at 11:36:09AM -0600, Tiger Wings wrote:
> > > > > > > > I did so.
> > > > > > > > But when execute psql, an error occurs:
> > > > > > > > database "tiger" does not exist.
> > > > > > >
> > > > > > > psql -l # gives you the list of existing databases
> > > > > > > createdb # will create database "tiger" (your login name)
> > > > > > > createdb other # will create database "other"
> > > > > > >
> > > > > > > Be aware to use the commands under $HOME/... not the
> > > > > > > system ones. If you intended to run another server
> > > > > > > on the system databases you just can't, unless you
> > > > > > > have write privileges on them.
> > > > > > >
> > > > > > > --strk;
> > > > > > >
> > > > > > > >
> > > > > > > > Thank you.
> > > > > > > >
> > > > > > > > T. W.
> > > > > > > > On Tue, 22 Mar 2005 09:58:09 +0100, strk at refractions.net
> > > > > > > > <strk at refractions.net> wrote:
> > > > > > > > > On Mon, Mar 21, 2005 at 08:26:16PM -0600, Tiger Wings wrote:
> > > > > > > > > > Hi there,
> > > > > > > > > >
> > > > > > > > > > I built postgresql 8.0 from the source code under Linux.
> > > > > > > > > > But I don't have root right on the system.
> > > > > > > > > > How can start the db server from my own directory?
> > > > > > > > > > Thanks a lot.
> > > > > > > > >
> > > > > > > > > Install under your homedir,
> > > > > > > > > Specify an arbitrary port not clashing with other running procs
> > > > > > > > > above 1024, and a datadir again under your home.
> > > > > > > > >
> > > > > > > > > $HOME/pgsql/bin/initdb #initialize the database
> > > > > > > > > $HOME/pgsql/bin/pg_ctl start # start the postmaster
> > > > > > > > > $HOME/pgsql/bin/psql # connect
> > > > > > > > >
> > > > > > > > > --strk;
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Cheers
> > > > > > > > > > T.W.
> > > > > > > > > > _______________________________________________
> > > > > > > > > > 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
> > > > > > > > >
> > > > > > > > _______________________________________________
> > > > > > > > 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
> > > > > > >
> > > > > > _______________________________________________
> > > > > > 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
> > > > >
> > > > _______________________________________________
> > > > 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
> > >
> > _______________________________________________
> > 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