ersions 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 | Democracy is three wolves
http://www.druid.net/da
ng to the correct library can you think of any other
issues with this?
--
D'Arcy J.M. Cain | 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:
n 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 c
ld be used in case of upgrade going wrong.
>
> Oh, so in contrast to "Oracle world" "Postgres world" DBA in their
> right to do major upgrade without complete and tested backup?
> Ok, I understand you. In Postgres world there always sky is blue and
On Tue, 10 May 2016 11:20:05 -0400
"D'Arcy J.M. Cain" wrote:
> On Tue, 10 May 2016 10:46:39 -0400
> George Neuner wrote:
> > On Linux (or Unix) you'd set up a forwarding record in iptables that
> > redirects a second port to Postgresql.
>
> Forwardi
anly, 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. Cain | Dem
On Tue, 10 May 2016 09:50:10 -0400
"D'Arcy J.M. Cain" 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 to pg_
"all@nobody" 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 id
t; 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
27;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
ven 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 | Democracy is three wolves
http://www.druid.net/darcy/
Basically I think that pg_hba.conf is missing a feature. We can
specify the database, the user and the address but we can't specify the
authenticated user. When it sees this;
provided user name (x) and authenticated user name (nobody) do not match
I would like it to connect with user x but dr
for a specific 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 | Democracy is three wolves
http://www.druid.net/darcy/|
one you would use to start a new thread on this list.
Some mailing list make it even easier by including a mail link at the
bottom of each message but this one doesn't.
Note that this is what I did with this message. It is not part of any
previous thread. It is the start of a new
he 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 | Democracy is three wolves
http://www.druid.net/darcy/
u submit your port to the community you could update when
you could or poke the community to do it for you. All hail open source.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 788 2246 (DoD#0082)
On Fri, 11 Apr 2014 09:16:04 -0400
Steve Litt wrote:
> Curious: Why not consider OpenBSD also?
Or NetBSD.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 788 2246 (DoD#0082)(eNTP) | wh
work already if
quotes are added:
box('(0, 1), (2, 3)')
--
D'Arcy J.M. Cain | 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, VoI
e of them from moving to a
> non-EU country (if they do, 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 a
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 | Democracy is t
eat them as distinct types.
--
D'Arcy J.M. Cain | 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-gener
ont end, just don't make a
> mistake there.
Yes, that's exactly why the money type exists.
--
D'Arcy J.M. Cain | 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
On Fri, 29 Mar 2013 23:32:20 +1100
Gavan Schneider 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 | Democracy is three
t precisions? Pick the higher precision? Forbid the
operation? The latter may make sense. How can you add Yen and US$?
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 788 2246 (DoD#0082)(eNT
t applied to a particular transaction. So while merely
Seems like something that can be stored in a different column.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 788 2246 (DoD#0082)(eNTP) |
es. 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 | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 788 2246 (DoD#0082)(eNT
ing is stored as an int. That means that you don't need to
convert data in the database 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 | Democracy is three wolves
http://ww
style license, there is nothing
in the GPL about using code for commercial use one way or the other.
--
D'Arcy J.M. Cain| 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.
Thus spake Stephen Davies
> I am currently writing a tool to replicate any database to a PostgreSQL mirror
> and the very first customer for this tool has several tables with 8 fields in
> their primary key. Sod's Law:-((
Could that database be badly in need of a redesign? :-)
29 matches
Mail list logo
