[ADMIN] msi installer: CREATESERVICEUSER and uninstall

2007-06-18 Thread Dirk . Moebius
Hi, the msi installer for Windows automatically creates a user 'postgres' if CREATESERVICEUSER=1. Is it possible to do the following: 1) don't create the user, if it already exists, and continue with installation, instead of showing the error message 'user postgres already exists'. 2) during

Re: [ADMIN] bugtraq post

2007-06-18 Thread Dawid Kuroczko
On 6/17/07, Ray Stell <[EMAIL PROTECTED]> wrote: For the security minded: Nico Leidecker <[EMAIL PROTECTED]> posted this to bugtraq yesterday, fyi. "I'd like to present a paper about security issues with PostgreSQL. The paper describes weaknesses in the configuration that may +allow attackers

Re: [ADMIN] bugtraq post

2007-06-18 Thread Ray Stell
On Mon, Jun 18, 2007 at 11:24:45AM +0200, Dawid Kuroczko wrote: > On 6/17/07, Ray Stell <[EMAIL PROTECTED]> wrote: > >Or as PDF at at > >http://www.portcullis.co.uk/uplds/whitepapers/Having_Fun_With_PostgreSQL.pdf > > Anyhow it's good to know that most vulnerabilities in PostgreSQL require > supe

[ADMIN] serverlog ownership

2007-06-18 Thread Pascal Robert
Hi, I want to cat /dev/null > serverlog every night (after the backup is done) so that this file keep a small size. Now, this file is owned by "root" and the backup is done by the user "postgres". I want to change the permissions so that : -rw-r--r-- 1 root root 43M Ju

Re: [ADMIN] bugtraq post

2007-06-18 Thread Ray Stell
I've never looked at windows. Here is an faq I found: http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html On Mon, Jun 18, 2007 at 06:44:31PM +0530, Jayakumar_Mukundaraju wrote: > Thanks for the mail... In this document, they specifies in unix and > linux box(server) configuration

[ADMIN] Converting a DB from SQL_ASCII to UTF-8

2007-06-18 Thread Michael Monnerie
Dear list, how would I convert an existing database (dbmail mail server, http://dbmail.org/) from SQL_ASCII to UTF-8? I cannot just dump and reload, because: psql:/mnt/dbmail:191030: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xdc62 TIP: Dieser Fehler kann auch auftreten, wenn die

Re: [ADMIN] AIX - best practices?

2007-06-18 Thread Andrew Sullivan
On Sat, Jun 16, 2007 at 12:00:36PM +0200, Dawid Kuroczko wrote: > Anyway, what are your feelings with regard to using PostgreSQL > under AIX? "Don't". This is just my personal opinion, and I don't speak for my employer (especially in this case!), but my feelings are that AIX is an awful, blet

[ADMIN] Postgres VS Oracle

2007-06-18 Thread David Tokmatchi
Hello from Paris I am DBA for Oracle and beginner on Postgres. For an company in France, I must make a comparative study, between Postgres and Oracle. Can you send any useful document which can help me. Scalability ? Performance? Benchmark ? Availability ? Architecture ? Limitation : users, volume

Re: [ADMIN] Postgres VS Oracle

2007-06-18 Thread Jonah H. Harris
On 6/18/07, David Tokmatchi <[EMAIL PROTECTED]> wrote: Scalability ? Performance? Benchmark ? Availability ? Architecture ? Limitation : users, volumes ? Resouces needed ? Support ? Aside from the Wikipedia database comparison, I'm not aware of any direct PostgreSQL-to-Oracle comparison. -- Jo

Re: [ADMIN] Postgres VS Oracle

2007-06-18 Thread Igor Neyman
This document: http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html could answer some of your questions. Igor From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Tokmatchi Sent: Monday, June 18, 2007 11:55 AM To: [EMAIL PROTECTE

Re: [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andreas Kostyrka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It's even harder, as Oracle disallows publishing benchmark figures in their license. As a cynic, I might ask, what Oracle is fearing? Andreas Jonah H. Harris wrote: > On 6/18/07, David Tokmatchi <[EMAIL PROTECTED]> wrote: >> Scalability ? Performance

Re: [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Jonah H. Harris
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote: As a cynic, I might ask, what Oracle is fearing? As a realist, I might ask, how many times do we have to answer this type of anti-commercial-database flamewar-starting question? -- Jonah H. Harris, Software Architect | phone: 732.331.1324

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Joshua D. Drake
Jonah H. Harris wrote: On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote: As a cynic, I might ask, what Oracle is fearing? As a realist, I might ask, how many times do we have to answer this type of anti-commercial-database flamewar-starting question? Depends? How many times are you goi

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread PFC
2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a database like PostgreSQL. We can compete in 90-95% of cases where people would traditionally purchase a proprietary system for many, many thousands (if not hundreds of thousands) of dollars. Oracle also fears benchmarks

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Joshua D. Drake
PFC wrote: 2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a database like PostgreSQL. We can compete in 90-95% of cases where people would traditionally purchase a proprietary system for many, many thousands (if not hundreds of thousands) of dollars. Oracle also fear

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Jonah H. Harris
On 6/18/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Depends? How many times are you going to antagonize the people that ask? As many times as necessary. Funny how the anti-proprietary-database arguments can continue forever and no one brings up the traditional RTFM-like response of, "hey, t

Re: [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andreas Kostyrka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonah H. Harris wrote: > On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote: >> As a cynic, I might ask, what Oracle is fearing? > > As a realist, I might ask, how many times do we have to answer this > type of anti-commercial-database flamewar-

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Joshua D. Drake
Jonah H. Harris wrote: On 6/18/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Depends? How many times are you going to antagonize the people that ask? As many times as necessary. Funny how the anti-proprietary-database arguments can continue forever and no one brings up the traditional RTFM-l

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andreas Kostyrka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 PFC wrote: > >> 2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a >> database like PostgreSQL. We can compete in 90-95% of cases where >> people would traditionally purchase a proprietary system for many, >> many thousands (if not

Re: [ADMIN] Converting a DB from SQL_ASCII to UTF-8

2007-06-18 Thread Ivo Rossacher
There is no general answer to the question. It highly depends on how the data was entered. SQL_ASCII is not an encoding but more the absence of any encoding. So whatever the client sends will be put into the database. So if you entered data with different encodings from the client side (typicall

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Jonah H. Harris
On 6/18/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Yeah funny how you didn't do that ;) (of course neither did I). I agree, an oops on my part :) It is amazing how completely misguided you are in this response. I haven't said anything closed minded. I only responded to your rather antagon

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andreas Kostyrka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonah H. Harris wrote: > > All of us have noticed the anti-MySQL bashing based on problems with > MySQL 3.23... Berkus and others (including yourself, if I am correct), > have corrected people on not making invalid comparisons against > ancient vers

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andrew Sullivan
All, On Mon, Jun 18, 2007 at 07:50:22PM +0200, Andreas Kostyrka wrote: [something] It would appear that this was the flame-fest that was predicted. Particularly as this has been copied to five lists. If you all want to have an argument about what Oracle should or should not do, could you at le

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Jonah H. Harris
On 6/18/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote: It would appear that this was the flame-fest that was predicted. Particularly as this has been copied to five lists. If you all want to have an argument about what Oracle should or should not do, could you at least limit it to one list? Ye

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andreas Kostyrka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonah H. Harris wrote: > Certainly, but can one expect to get a realistic answer to an, "is > Oracle fearing something" question on he PostgreSQL list? Or was it > just a backhanded attempt at pushing the topic again? My vote is for > the latter; i

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andrew Sullivan
On Mon, Jun 18, 2007 at 02:16:56PM -0400, Jonah H. Harris wrote: > pgsql-advocacy... your thoughts? I've picked -advocacy. > > I think the Oracle discussion is over, David T. just needs URL references > IMHO. I don't think we can speak about Oracle; if we were licenced, we'd be violating it, a

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Andrew Sullivan
On Mon, Jun 18, 2007 at 02:38:32PM -0400, Andrew Sullivan wrote: > I've picked -advocacy. Actually, I _had_ picked advocacy, but had an itchy trigger finger. Apologies, all. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Adam Tauno Williams
> > Depends? How many times are you going to antagonize the people that ask? > As many times as necessary. Funny how the anti-proprietary-database > arguments can continue forever and no one brings up the traditional > RTFM-like response of, "hey, this was already discussed in thread XXX, > read t

[ADMIN] Explained by known hardware failures, or keep looking?

2007-06-18 Thread Kevin Grittner
Linux version 2.6.5-7.252-bigsmp ([EMAIL PROTECTED]) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Tue Feb 14 11:11:04 UTC 2006 PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE Linux) Database 212GB on RAID 5. 4 x Intel(R) XEON(TM) MP CPU 2.00GHz total

Re: [ADMIN] Explained by known hardware failures, or keep looking?

2007-06-18 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > Could all of this be reasonably explained by the controller failure and/or = > the subsequent abrupt power loss, or should I be looking for another cause?= > Personally, as I look at this, I'm suspicious that either the controller = > didn't persist

Re: [ADMIN] Explained by known hardware failures, or keep looking?

2007-06-18 Thread Simon Riggs
On Mon, 2007-06-18 at 14:41 -0500, Kevin Grittner wrote: > [2007-06-14 11:31:05.986 CDT] 6781 LOG: redo starts at 1D2/6C739064 > [2007-06-14 11:31:46.533 CDT] 6781 WARNING: invalid page header in block > 182566 of relation "1523860"; zeroing out page > [2007-06-14 11:31:46.533 CDT] 6781 CONTEXT

Re: [ADMIN] Postgres VS Oracle

2007-06-18 Thread Rodrigo De León
On Jun 18, 10:55 am, [EMAIL PROTECTED] ("David Tokmatchi") wrote: > Hello from Paris > I am DBA for Oracle and beginner on Postgres. For an company in France, I > must make a comparative study, between Postgres and Oracle. Can you send any > useful document which can help me. > Scalability ? Perfo

Re: [ADMIN] bugtraq post

2007-06-18 Thread Dawid Kuroczko
On 6/18/07, Ray Stell <[EMAIL PROTECTED]> wrote: On Mon, Jun 18, 2007 at 11:24:45AM +0200, Dawid Kuroczko wrote: > On 6/17/07, Ray Stell <[EMAIL PROTECTED]> wrote: > >Or as PDF at at > >http://www.portcullis.co.uk/uplds/whitepapers/Having_Fun_With_PostgreSQL.pdf > > Anyhow it's good to know that

[ADMIN] Server and Client configuration.

2007-06-18 Thread Jayakumar_Mukundaraju
I am new to Postgresql Database. My setup is backend is postgresql database, frontend is Java(JDBC). I installed the postgres in windows platform. Now I want to setup server and client configuration. Kindly guide me how to set the configuration parameters, in server and client machines. Waiting for