Re: [GENERAL] Allowing multiple versions of PG under NetBSD

at anyone running multiple versions knows how to specify all that stuff when initializing and starting the different servers. From the comments I saw it looked to me like other systems (Linux?) had already solved this problem. Was I wrong? -- D'Arcy J.M. Cain <da...@druid.net> | Democracy

Re: [GENERAL] Allowing multiple versions of PG under NetBSD

9.3 Other than linking to the correct library can you think of any other issues with this? -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for d

Re: [GENERAL] Uber migrated from Postgres to MySQL

e downtime you can also delete PG, install the new version and run pg_upgrade without modifying the existing DB. If it succeeds then replace the directories and restart the new version. If it fails then uninstall PG, reinstall the older version and restart. Lather, rinse, repeat until it upgrades

Re: [GENERAL] Uber migrated from Postgres to MySQL

rld there always sky is blue and > sun is shining. Yikes! Where did you read that? -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: d

Re: [GENERAL] Using both ident and password in pg_hba.conf

On Tue, 10 May 2016 11:20:05 -0400 "D'Arcy J.M. Cain" <da...@druid.net> wrote: > On Tue, 10 May 2016 10:46:39 -0400 > George Neuner <gneun...@comcast.net> wrote: > > On Linux (or Unix) you'd set up a forwarding record in iptables that > > redirects a se

Re: [GENERAL] Using both ident and password in pg_hba.conf

idea will do the job cleanly, or at least as cleanly as I can expect. > I don't know offhand a way to do that on Windows, but I presume that > it is possible. Luckily I could care less about Windows or Linux for that matter. Unix is all I run on my servers. -- D'Arcy J.M. Cai

Re: [GENERAL] Using both ident and password in pg_hba.conf

On Tue, 10 May 2016 09:50:10 -0400 "D'Arcy J.M. Cain" <da...@druid.net> wrote: > Can you expand on this? I can't seem to get my head around it. How > does the client make it look like it is coming from this ersatz > loopback IP? In fact, I don't even need to add this t

Re: [GENERAL] Using both ident and password in pg_hba.conf

obody" field is meant to specify that the remote user is > > nobody but that they are connecting as user joe. > > As John noted, we don't have any idea what the "remote username" is > at the time we're scanning pg_hba.conf. So how do you do ident then? -- D'Arcy J.

Re: [GENERAL] Using both ident and password in pg_hba.conf

name, and if > its 'host', the source IP address. this is used to select the > desired authentication method for that combination. Yes, it is missing that one piece I suggested - the ability to select based on the authenticated name. That's what I am trying to work around. -- D'A

Re: [GENERAL] Using both ident and password in pg_hba.conf

uldn't like to expose them, even to us. Of course PHP scripts have to run as nobody so I have no choice other than to have them store passwords in various config.php files but PHP users are used to that. I would like to fix that but that's a war for another day. -- D'Arcy J.M. Cain <da.

Re: [GENERAL] Using both ident and password in pg_hba.conf

need to do an ident check unless the auth method is "trust" which would be silly anyway. In fact "password" is the only method that even makes any sense at all. -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/

Re: [GENERAL] Using both ident and password in pg_hba.conf

user x but drop to password authentication. -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net, VoIP: sip:da...@druid.net

[GENERAL] Using both ident and password in pg_hba.conf

cific user. As a result it isn't recognized by the first line so it tries ident anyway and fails. Is there any way to accomplish what I want? Any help appreciated. Cheers. -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/

[GENERAL] Off topic - How to start a new thread

. It is not part of any previous thread. It is the start of a new (hopefully short) thread. -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner

Re: [GENERAL] How can I group all children by their parent ?

of anyone in the database. Try for that level of detail and you will probably get more useful answers. Also, see http://www.catb.org/~esr/faqs/smart-questions.html for some useful hints on asking questions. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http

Re: [GENERAL] Linux vs FreeBSD

On Fri, 11 Apr 2014 09:16:04 -0400 Steve Litt sl...@troubleshooters.com wrote: Curious: Why not consider OpenBSD also? Or NetBSD. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246

Re: [GENERAL] Linux vs FreeBSD

could or poke the community to do it for you. All hail open source. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net, VoIP

Re: [GENERAL] How do I create a box from fields in a table?

already if quotes are added: box('(0, 1), (2, 3)') -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net, VoIP: sip:da

Re: [GENERAL] Checking for changes in other tables

, the loan has to be cancelled first). They are however allowed to move to other EU countries. Wouldn't two constraints, one for each of donor and recipient, do the job? Moving a person out of the EU would have the same effect as deleting them. The constraint would prevent it. -- D'Arcy J.M

Re: [GENERAL] Money casting too liberal?

On Fri, 29 Mar 2013 23:32:20 +1100 Gavan Schneider pg-...@snkmail.com wrote: Is there a Godwin's law I am formulating Cain's Law. Something like If a discussion lasts long enough, someone will mention Godwin's Law. :-) -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves

Re: [GENERAL] Money casting too liberal?

don't make a mistake there. Yes, that's exactly why the money type exists. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da

Re: [GENERAL] Money casting too liberal?

as distinct types. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net, VOIP: sip:da...@vex.net -- Sent via pgsql-general

Re: [GENERAL] Money casting too liberal?

or always credit? I have a G/L system and most money columns either don't know about Dr/Cr or else there is another column with the G/L account which implies Dr/Cr. Where do you see a column that would be dedicated to one or the other? -- D'Arcy J.M. Cain da...@druid.net | Democracy

Re: [GENERAL] Money casting too liberal?

Seems like something that can be stored in a different column. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net, VOIP: sip:da

Re: [GENERAL] Money casting too liberal?

? Forbid the operation? The latter may make sense. How can you add Yen and US$? -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net

Re: [GENERAL] Money casting too liberal?

to a machine representation before summing, averaging, etc. The machine can generally work on the data as it comes out of the DB. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [GENERAL] Money casting too liberal?

. If a column is tracking Yen it should always be Yen. Y10,000 should never display as $100.00 just because the locale changes. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD

Re: [HACKERS] Re: [GENERAL] Revised Copyright: is this more palatable??

is nothing in the GPL about using code for commercial use one way or the other. -- D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.