[postgis-users] installing postgis in Ubuntu 5.10(Breezy)
blair at orcaware.com
Wed Mar 8 21:47:19 PST 2006
On Mar 8, 2006, at 4:32 AM, Mikael Schröder wrote:
> 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/
> /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
> ???? 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 /
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
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.
Blair Zajac, Ph.D.
<blair at orcaware.com>
Subversion training, consulting and support
More information about the postgis-users