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

[strk at refractions.net]

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