Re: [ADMIN] newbie question

2001-07-10 Thread Xue-Feng Yang
--- Henry House <[EMAIL PROTECTED]> wrote: > On Tue, Jul 10, 2001 at 10:02:03PM -0400, Xue-Feng > Yang wrote: > > Sounds that the postmaster does not listen on TCP. > > How can I add it to TCP? > > You need to pass the -i switch to the postmaster > when starting it. Most > likely your distributio

Re: [ADMIN] newbie question

2001-07-10 Thread Henry House
On Tue, Jul 10, 2001 at 08:26:56PM -0400, Xue-Feng Yang wrote: > Can anyone help me on the following problem? > > $psql -h localhost > > psql: PQconnectPoll() -- connect() failed: Connection > refused > Is the postmaster running (with -i) at > 'localhost' > and accepting connecti

Re: [ADMIN] newbie question

2001-07-10 Thread Grant
Well is postmaster running with i? ps auwx | grep post ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] newbie question

2001-07-10 Thread Xue-Feng Yang
Can anyone help me on the following problem? $psql -h localhost psql: PQconnectPoll() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port '5432'? _

[ADMIN] A free ODBC client to use with any database.

2001-07-10 Thread Petarian
Hello, Try WinSQL at http://www.indus-soft.com/winsql. It is absolutely FREE and does not expire. It is only one file and does not come with any bulky DLLs. If you don't like it, simply delete the file from your harddisk. Features: -- * Connect to any database through ODBC * Syntax Highl

[ADMIN] STANDALONE

2001-07-10 Thread Sudheer Palapparambil
Hello, Can we run server and client on a single machine logged in as user postgres. Will it give any problems ? Sudheer ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[ADMIN] Disk Page Fetches

2001-07-10 Thread Dennis
When you use explain, it gives you a cost estimate in units of disk page fetches. How can I tell how many disk page fetches my machine is likely to do/second and how long the query might actually take? -Dennis ---(end of broadcast)--- TIP 5: Have

Re: [ADMIN] problem in compilation.

2001-07-10 Thread Peter Eisentraut
Namrata writes: > 1. We had to make the following changes to the configure script, which > was not otherwise recognizing the presence of some libraries. If you want us to be able to fix this in the master sources you need to 1. post what you did and what you got in the screen when things went w

Re: [ADMIN] problem in compilation.

2001-07-10 Thread Namrata
Hi There, 1. We had to make the following changes to the configure script, which was not otherwise recognizing the presence of some libraries. The modifications in the configure script are the following A. Removal of -Wl from LDFLAGS B. Addition of an empty main function ( int main() { ; retu

[ADMIN] Quick Question!

2001-07-10 Thread Harry Yau
Hi: A really simple question: I wanna set up some WAL related config parameter. I am wondering is it the same to add those parameter on postgresql.conf as to add them on /etc/rc.d/init.d/postgres.init?? ---(end of broadcast)--- TIP 5: Have you chec