Thread: psql client binary

psql client binary

From
Mark Morgan Lloyd
Date:
Hopefully not to grievous an FAQ: can anybody point me at a precompiled binary
of the psql terminal-based front-end to run on NT hopefully not requiring
Cygwin, or has this been effectively replaced by pgAdmin?

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

Re: psql client binary

From
Bruce Momjian
Date:
Mark Morgan Lloyd wrote:
> Hopefully not to grievous an FAQ: can anybody point me at a precompiled binary
> of the psql terminal-based front-end to run on NT hopefully not requiring
> Cygwin, or has this been effectively replaced by pgAdmin?

pginstaller has such a psql binary that should work on NT, but it will
not install on NT.  See the FAQ:

    http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html

--
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +

Re: psql client binary

From
Mark Morgan Lloyd
Date:
Bruce Momjian wrote:
>
> Mark Morgan Lloyd wrote:
> > Hopefully not to grievous an FAQ: can anybody point me at a precompiled
> > binary of the psql terminal-based front-end to run on NT hopefully not
> > requiring Cygwin, or has this been effectively replaced by pgAdmin?
>
> pginstaller has such a psql binary that should work on NT, but it will
> not install on NT.  See the FAQ:
>
>         http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html

Thanks Bruce. So in general NT4 is out as a client and I might not even be able
to install pgAdmin as a binary. Bit of a bother that- I'm hoping to get clients
and users onto Linux RSN but until then being able to e.g. cut-and-paste out of
psql is something I find very useful indeed.

Alternatively is there a binary somewhere of the psql client that uses the
Cygwin DLL?

Apologies for sounding like a total wimp, I'm an embedded-systems guy who also
does Delphi on PCs. I'm up to a bit of C hacking under Linux but have never
dirtied my hands with C or C++ on Win-32.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

Re: psql client binary

From
"Magnus Hagander"
Date:
> > > Hopefully not to grievous an FAQ: can anybody point me at a
> > > precompiled binary of the psql terminal-based front-end
> to run on NT
> > > hopefully not requiring Cygwin, or has this been
> effectively replaced by pgAdmin?
> >
> > pginstaller has such a psql binary that should work on NT,
> but it will
> > not install on NT.  See the FAQ:
> >
> >
> > http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
>
> Thanks Bruce. So in general NT4 is out as a client and I
> might not even be able to install pgAdmin as a binary. Bit of
> a bother that- I'm hoping to get clients and users onto Linux
> RSN but until then being able to e.g. cut-and-paste out of
> psql is something I find very useful indeed.

The client should work on NT4. It's the server that has some problems.
And th einstlaler itself. But if you use the binaries-no-installer
distribution (it's on the ftp site), you should be able to use it.

Not sure about pgAdmin.


> Alternatively is there a binary somewhere of the psql client
> that uses the Cygwin DLL?

I think there may be on ein the actual Cygwin distribution, but I'm not
sure - it may also be an old verison.


//Magnus

Re: psql client binary

From
"Dave Page"
Date:

-----Original Message-----
From: "Mark Morgan Lloyd"<markMLl.pgsql-general@telemetry.co.uk>
Sent: 26/02/06 14:33:55
To: "pgsql-general@postgresql.org"<pgsql-general@postgresql.org>
Subject: Re: [GENERAL] psql client binary

> Thanks Bruce. So in general NT4 is out as a > client and I might not even be able
> to install pgAdmin as a binary.

Use the no-installer win32 package (it's just a zip of the core server files), psql should run on any version of
windowsfrom 95. You'll need some of the dlls as well - from memory: 

Libpq.dll
Libintl.dll
Libiconv.dll
Comerr32.dll
Krb5_32.dll
Libeay32.dll
Ssleay32.dll

And pgAdmin /should/ work as well, but I don't know if anyone has tried it on NT4 in a while.

Regards, Dave

-----Unmodified Original Message-----
Bruce Momjian wrote:
>
> Mark Morgan Lloyd wrote:
> > Hopefully not to grievous an FAQ: can anybody point me at a precompiled
> > binary of the psql terminal-based front-end to run on NT hopefully not
> > requiring Cygwin, or has this been effectively replaced by pgAdmin?
>
> pginstaller has such a psql binary that should work on NT, but it will
> not install on NT.  See the FAQ:
>
>         http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html

Thanks Bruce. So in general NT4 is out as a client and I might not even be able
to install pgAdmin as a binary. Bit of a bother that- I'm hoping to get clients
and users onto Linux RSN but until then being able to e.g. cut-and-paste out of
psql is something I find very useful indeed.

Alternatively is there a binary somewhere of the psql client that uses the
Cygwin DLL?

Apologies for sounding like a total wimp, I'm an embedded-systems guy who also
does Delphi on PCs. I'm up to a bit of C hacking under Linux but have never
dirtied my hands with C or C++ on Win-32.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend