[postgis-users] installing postgis in Ubuntu 5.10(Breezy)

[Blair Zajac]

On Mar 8, 2006, at 4:32 AM, Mikael Schröder wrote:

> Blair,
> Yes everything finally installed fine!
> But were is the configuration file and the services autostart file?
> I ran:
> /usr/lib/postgresql/8.1/bin/initdb --pgdata=/var/lib/postgresql/8.1/ 
> data
> /usr/lib/postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/data
>
> But got the message that the server was already started, and thus  
> the port bussy.
> I killed the Postgres services och restarted it with:
> /usr/lib/postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/ 
> data  -i
> And after that It started up allright and I could connect to the  
> database through pgadmin3 at localhost.
> After I restarted the computer the postgres-service was once more  
> without the -i option.
> and I found that /etc/postgresql/8.1/main contained another (or  
> rather the first database location). I changed that postgresql.conf to
> listen_addresses = 'localhost' and restarted the computer. But once  
> more the server started without the -i option or without access via  
> localhost.
> ???? were do I make the changes so that I can connect to my  
> database with pgadmin3?
> Regards Mikael

Everything is in /etc/postgresql*.  The stop/start scripts are in / 
etc/init.d/postgresql-8.1.

I would use the default locations for postgresql, as all the  
postgresql* (especially the postgresql-common) packages are designed  
to use the default location.  I would recommend deleting your custom  
installation and using everything the way the packages are set up to  
be used.

Maybe postgresql was set up to listen to TCP connections, but the  
permissions were not enabled.  Check the pg_hba.conf file.  Also,  
look at the 'netstat -an' output to see if there's something  
listening on the expected port.

This discussion probably doesn't belong on postgis-users list.

Regards,
Blair

-- 
Blair Zajac, Ph.D.
<blair at orcaware.com>
Subversion training, consulting and support
http://www.orcaware.com/svn/