If you ask me, yes. When I had to choose between MySQL 3.x and
PostgreSQL 6.5 a long ago and I was able to exclude the DB superuser
with REVOKE CONNECT from MySQL, I said "no, thanks".
I did it on purpose to prove that you can the external configuration
is better in this case.
And apart from fixing pg_hba.conf after you move the machine,
PostgreSQL is quite location agnostic network-wise.
You can modify the IP address[es] and FQDN of the machine,
which is not easily doable if you use e.g. Informix where the hostname
is stored deep inside the DB and some subsystems break if it changes.
Harpreet Dhaliwal írta:
> is the host base configuration methodology in postgres superior to
> other RDBMS.
> is this something novel that postgres has come up with?
>
> ~Harpreet
>
> On 5/26/07, * Tom Lane* <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>>
> wrote:
>
> Stefan Kaltenbrunner < stefan@kaltenbrunner.cc
> <mailto:stefan@kaltenbrunner.cc>> writes:
> > Tom Lane wrote:
> >> A more interesting question is what sort of hardware you need
> for that
> >> actually to be a win, though. Loading a few tables in parallel
> sounds
> >> like an ideal recipe for oversaturating your disk bandwidth...
>
> > you don't actually need that much of disk bandwidth both COPY
> and CREATE
> > INDEX are CPU bottlenecked on modern boxes and reasonable disk
> > subsystems - spreading their work over multiple cores/processes
> can give
> > big benefits.
>
> Hmm ... I wonder if that's true for COPY BINARY ...
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/