Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

ssibility properties. cu -- -- Enrico Weigelt, metux IT service -- http://www.metux.de/ phone: +49 36207 519931 email: weig...@metux.de mobile: +49 151 27565287 icq: 210169427 skype:

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

on, nominal parameters are too vague for enterprise usage. (no, you can't even tell that DAS is faster than SAN). You need to test your workload and then decide which product to use. cu -- ------ Enrico Weigelt, metux IT serv

Re: [ADMIN] linux standard layout

and build machinery in the back. I'm often work in embedded or specific appliance environments and have developed my several tools which make this easier. (feel free to contact me personally if you're interested) cu -- ------

Re: [ADMIN] linux standard layout

BI rpm and compile it also from the source, or whether > I should use standard rpms for postgresql as well. (DBI may not be a good > example.) Pathes should be configurable, or you could use symlinks or bind mounts. cu -- --

Re: [ADMIN] Virtualization vs. sharing a server

w/ PostgreSQL and other RDBM'es. cu -- ----- Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Taskforce: http://wiki.metux.de/public/Op

[ADMIN] dump diffs even w/o db changes

This unnecessarily pollutes the history and procudes high load when git-gc / git-repack runs. Is there any way to get rid of these differences ? cu - - Enrico Weigelt== metux IT service - http://www.met

[ADMIN] pg_dumpall + pgdump_oid table + incremental backup

. Is there any way around this ? thx -- - Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Taskforce:

[ADMIN] Suggested HW for postgres ?

st ? cu -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL

Re: [ADMIN] where with NULL values are not selected

able1.column=table2.column) OR ((table1.column IS NULL) AND (table2.column IS NULL)); cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://w

[ADMIN] Some Tip: take care to run routine vacuum as superuser ...

.. I'm not getting younger ... ;-) cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 362

Re: [ADMIN] brute force attacking the password

ssible to do this directly in the database - by rules and triggers on the appropriate system tables ? cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax:

Re: [ADMIN] brute force attacking the password

* Bruno Wolff III <[EMAIL PROTECTED]> wrote: > Maybe you can use client side certificates. how can they be used w/ psql ? cu -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www:

Re: [ADMIN] Suse 9.2 stops booting while starting the postgres-server

r now comes up properly ? cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

Re: [ADMIN] thats funny :)

deep recursion instead of just crashing on stack overflow. cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [

Re: [ADMIN] A nightmare

4:46 MSK 2005 i686 i686 i386 GNU/Linux. I have no trust or > distrust against it. you probably have a qouta ? cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux

[ADMIN] ODBC + pgsql on win32

doing wrong ? thx -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] -

Re: [ADMIN] REMOVE

list server has an filter for that, btw. cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

[ADMIN] measuring most-expensive queries

aster can log ev'ry single statement, but its really too for a human person, to read the log files. Is there any tool for that ? thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www:

Re: [ADMIN] Suse 9.2 stops booting while starting the postgres-server

the database, which now requires a password in your configuration. Of course psql is prompting for it, but you problably dont see it. You'll have to rewrite the pgsql boot script. Maybe you'd like to move away from GNU/Windows .. ;-P cu -- ----

Re: [ADMIN] Database Encryption (now required by law in Italy)

really mean. Representants voting for some law they cannot explain to plain people should get corporal punishment. cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fa

[ADMIN] security via views

on ? thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +49 1

Re: [ADMIN] cost of empty fields

ere's really enough time for vacuum full analyze :) cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

[ADMIN] cost of empty fields

r this. thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +4

Re: [ADMIN] cast not IMMUTABLE?

mestamptz was just an question of presentation. cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED]

[ADMIN] public key authentification

Hi folks, is there a way to do pubkey authentification (like ssh) with postgresql and the psql frontend ? thx. -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http

Re: [ADMIN] Multi-Master Replication

e well. regards, -- ----- Enrico Weigelt== metux IT services phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone

[ADMIN] Running postgresql on an memory stick

Hi folks, as anyone tested tunning postgresql on a memory stick ? cu -- - Enrico Weigelt== metux IT services phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

Re: [ADMIN] xml output

eplacement which understands this. cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax:

Re: [ADMIN] replication/redundancy

ther account transfers, rather than both, if two > occured at the same time. Well, for such applications, the actual account value must be calculated from an checkpoint and the lasted transactions. Checkpoints may be made only by an master (which may change from time to time) cu --

Re: [ADMIN] replication/redundancy

currently no real conflict handling perhaps we can improve this a little bit. cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931

Re: [ADMIN] replication/redundancy

ly-written databases - conflicts may occour. i didnt find an better solution yet, but still works for all of my apps, even running over email :) cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, r

Re: [ADMIN] Postgres RoadMap

have smoked ? ;-) cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932

Re: [ADMIN] Can the frontend get notifications from the postgres server?

needed :) cu -- - Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cell

Re: [ADMIN] Can the frontend get notifications from the postgres server?

the client lib, to the php script. When using psql, the NOTIFY is displayed after sending an query. It seems that it is sent within the server's reply to the query. But i dont know how the clientlib hands it to the application. cu -- -------

Re: [ADMIN] Can the frontend get notifications from the postgres server?

for this ? cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [

Re: [ADMIN] Can the frontend get notifications from the postgres server?

receive notifies in php ... that's what i'm really interested in ... cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931