Thank you Tom Lane and Phillip Smith, you've answered my questions.
--Geoff
On Jun 15, 2006, at 22:46, Tom Lane wrote:
Geoffrey Knauth <[EMAIL PROTECTED]> writes:
Andrew Sullivan wrote:
Well, do you actually have an interface with that address?
I think I do, in that th
ress and 1.33 is on the same subnet. Or maybe
I'm misunderstanding. I thought the purpose of listen_addresses was
to allowing incoming connections only from listed addresses.
Geoff
On Jun 15, 2006, at 10:40, Tom Lane wrote:
Geoffrey Knauth <[EMAIL PROTECTED]> writes:
I'
I'm running PostgreSQL 8.1.3. In my postgresql.conf, the following
works:
listen_addresses = '*'
but the following does not:
listen_addresses = '192.168.1.33'
I get an error:
WARNING: could not create listen socket for "192.168.1.33"
FATAL: could not create any TCP/IP sockets
I
That did exactly what I wanted. Thank you! (I had tried \set
acct ... before, but it was your quoting that fixed my problem.)
Geoffrey
--
Geoffrey S. Knauth | http://knauth.org/gsk
On Sep 15, 2005, at 18:43, Michael Fuhr wrote:
What's your intention here? The above sets the variable tmp
I want to do something like this:
\set tmp :acct 'a value'
\i query.sql
where query.sql looks like this:
select sum(amount), dr_acct from ledger where dr_acct = :acct
group by dr_acct;
select sum(amount), cr_acct from ledger where cr_acct = :acct
group by cr_acct;
selec
