[Camps-users] Camps with PostgreSQL on Debian

[David Christensen]

Racke,

> However, with PostgreSQL on Debian the default location for Unix sockets / lock files is
> /var/run/postgresql/ instead of /tmp. Of course, this directory is restricted to used by
> PostgreSQL:
> 
> FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.8916.lock": Permission denied
> 
> OK, so I figured that I can change the location of this directory in pgsql/postgresql-8.4.conf to
> 
> unix_socket_directory = '__CAMP_DB_TMPDIR__'
> 
> The next problem was that psql is _not_ connecting to TCP port 8916 with psql -p 8916 unless
> you supply -h localhost as well.
> 
> It would be useful for psql_camp to have an option for the socket file instead of using TCP port
> of the localhost.

Thanks for the reports, I don't know of anyone else using Debian at this point, so it'll be good to figure out any quirks (such as the use of the pg_wrapper scripts).  When these were written we hadn't taken that into consideration, so there will ideally be adjustments that can work regardless of OS.

Regards,

David
--
David Christensen
End Point Corporation
david at endpoint.com