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
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
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
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
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
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
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
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
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
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
-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
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
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
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
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
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
-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-
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
-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
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
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
-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
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
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
-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
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
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
> > 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
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
"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
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
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
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
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
34 matches
Mail list logo