Zoltan Boszormenyi írta:
> 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.
I wanted to write "you can reenable the superuser to fix problems later,
so the external configuration is better".
And sorry for the top-posting.
> 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/