Re: [ADMIN] Connection problem (newbie question)

Thanks TaChung, and I tried that, but unfortunately the end result was the same: $ psql template1 psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Connecting to the port

Re: [ADMIN] Connection problem (newbie question)

HI Paul: you would need to specify a database name such as the "template1". The "template1" database is installed by default as you install PostgreSQL. psql If you do not specify a database name, the default database name that psql will use is 'postgresql" Regards TaChung Huang (¶À¤j©¾)

[ADMIN] Connection problem (newbie question)

Hi, I've just installed Postgresql 7.3 via Cygwin on Win2K, started the postmaster successfully, yet cannot connect using psql. See below for trace: $ pg_ctl start -D /usr/share/postresql/data -l serverlog postmaster successfully started $ psql psql: could not connect to server: No such file or

[ADMIN] Locale problem with LC_MESSAGES

Hi all, I just installed cygwin/cygipc/postgresql 7.3 (i386 binary) on my W2K box. Then I did a initdb -W -D /cygdrive/d/apps/cygwin/usr/local/pgsql/data --locale=de_CH --encoding=UNICODE this seemed to work OK. Now when I try to start the postmaster, I get the error message invalid value for o

Re: [ADMIN] list schema

Peter Childs writes: > I also notice that on the todo list is a job to turn all these into views. > It might be worth doing that (should not be too difficult I think) plus > they could then be used from other client programs. That would be really nice! Tilo ---(end

Re: [HACKERS] [ADMIN] how to alter sequence.

Thanks---Good Suggestion. I think it will solve my problem. raja --- "Ross J. Reedstrom" <[EMAIL PROTECTED]> wrote: > On Thu, Dec 05, 2002 at 02:18:15PM -0500, Bruce > Momjian wrote: > > > > I don't think you can drop/recreate the sequence > because the dependency > > code knows other tables depen