Re: [GENERAL] odbc with debian woody/postgres
> > I can't for the life of me get postgresql to start and stop. running > /etc/init.d/postgresql stop gets me this: > > Stopping PostgreSQL database: postmaster > /etc/init.d/postgresql: command not found > > while running > /usr/lib/postgresql/bin/pg_ctl-D /var/lib/postgres/data stop > gives the following: > > pg_ctl: cannot find /var/lib/postgres/data/postmaster.pid > Is postmaster running? Do you run /etc/init.d/postgresql as root? "start-stop-daemon" is (in my system at least) located in /sbin so ordinary users usually don't find it (/sbin is not in their path). Best regards, Emil -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [GENERAL] odbc with debian woody/postgres
On Thu, 10 Oct 2002 02:17, Matt Price wrote: > On Wed, Oct 09, 2002 at 08:56:49AM +0200, Michael Meskes wrote: > > On Wed, Oct 09, 2002 at 02:22:38AM -0400, Matt Price wrote: > > > localall trust > > > host all 127.0.0.1 255.0.0.0 ident > > > > Here you tell PostgreSQL to use ident. > > hmm, ok, I'll take out that line -- though I would have thought > that, since I'm connecting from localhost, this wouldn't be an issue. > > > Sorry I don't fully understand that. You define one ODBC conenction for > > exactly one database, so what are you looking for? > > that's the reply I was looking for -- I didn't undersetand exactly how > ODBC works. > > I can't for the life of me get postgresql to start and stop. running > /etc/init.d/postgresql stop gets me this: > > Stopping PostgreSQL database: postmaster > /etc/init.d/postgresql: start-stop-daemon: command not found > > while running > /usr/lib/postgresql/bin/pg_ctl-D /var/lib/postgres/data stop > gives the following: > > pg_ctl: cannot find /var/lib/postgres/data/postmaster.pid > Is postmaster running? > > I guess I'm missing something important, but it's not evident what > when I read the docs. any help is appreciated! thanks, > m I'm not on top of this by any means but even from localhost there are2 ways to connect, via tcp/ip and by unix socket. When you connect by pgsql you are using the unix socket - i think. Connection issues are dicussed very fully on the posgresql admin mailing list see http://www.postgresql.org HTH Bob -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [GENERAL] odbc with debian woody/postgres
On Wed, Oct 09, 2002 at 08:56:49AM +0200, Michael Meskes wrote: > On Wed, Oct 09, 2002 at 02:22:38AM -0400, Matt Price wrote: > > localall trust > > host all 127.0.0.1 255.0.0.0 ident > > Here you tell PostgreSQL to use ident. hmm, ok, I'll take out that line -- though I would have thought that, since I'm connecting from localhost, this wouldn't be an issue. > Sorry I don't fully understand that. You define one ODBC conenction for > exactly one database, so what are you looking for? > that's the reply I was looking for -- I didn't undersetand exactly how ODBC works. I can't for the life of me get postgresql to start and stop. running /etc/init.d/postgresql stop gets me this: Stopping PostgreSQL database: postmaster /etc/init.d/postgresql: start-stop-daemon: command not found while running /usr/lib/postgresql/bin/pg_ctl-D /var/lib/postgres/data stop gives the following: pg_ctl: cannot find /var/lib/postgres/data/postmaster.pid Is postmaster running? I guess I'm missing something important, but it's not evident what when I read the docs. any help is appreciated! thanks, m -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: [GENERAL] odbc with debian woody/postgres
On Wed, Oct 09, 2002 at 02:22:38AM -0400, Matt Price wrote: > localall trust > host all 127.0.0.1 255.0.0.0 ident Here you tell PostgreSQL to use ident. > ps: assuming I get thisworking, how do I add other database names to > odbc.ini? Do I need whole new sections (like > "[Postgresql/dbname]") or can I just add the dbnames to the Database > line of the file? Sorry I don't fully understand that. You define one ODBC conenction for exactly one database, so what are you looking for? Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]