-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/25/07 01:28, Alex Turner wrote:
> Why the hell would you buy a 1U chassis in the first place when
> perfectly good cheap 4U chassis exists that will take 8 or more drives?
>
> 1U motherboards are a pain, 1U power supplies are a pain and 1U spa
Hi all,
i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on
a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4
running with the data on a DRBD Device for High Availability. The used
database is also replicated to two similar machines with slony1.
Since the loa
Hello
maybe you have to tune bgwriter. Please, read this article
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm
Regards
Pavel Stehule
On 25/11/2007, Peter Bauer <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on
On Sun, Nov 25, 2007 at 02:53:03AM -0200, [EMAIL PROTECTED] wrote:
> I'm having serious problems with PostGreSQL and Windows Server 2003
> Enterprise Edition. The PostgreSQL Server doesn't start if I set the shared
> buffers higher than 1GB. All my programs can use only 3 GB of RAM and I have
> 8G
I am referring to client side computing - no SQL changes can be applied.
Is there a LIBPQ dll extension that supports sliding windows like
management
Of the *PGresult array?
Thanks
Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
[EMAIL PROTECTED]
---(end
On Sun, Nov 25, 2007 at 05:51:20AM -0600, Abraham, Danny wrote:
> I am referring to client side computing - no SQL changes can be applied.
>
> Is there a LIBPQ dll extension that supports sliding windows like
> management
> Of the *PGresult array?
Sliding windows I don't know. It is possible to s
Hello,
I changeded shared buffers to 256 MB. But I still receiving the error message.
So I changed to 128 MB, and I received the error again.
I'm using a cursor via ODBC.
Thanks,
Cláudia.
> On Sun, Nov 25, 2007 at 02:53:03AM -0200, [EMAIL PROTECTED]
> wrote:
>> I'm having serious problems w
On Sun, Nov 25, 2007 at 10:38:31AM -0200, [EMAIL PROTECTED] wrote:
> Hello,
>
> I changeded shared buffers to 256 MB. But I still receiving the error message.
> So I changed to 128 MB, and I received the error again.
> I'm using a cursor via ODBC.
Are you using a cursor, because it certainly does
Hi,
Here is a piece of psqlodbc log file:
[0.000]conn=02DE3A70, PGAPI_DriverConnect(
in)='DSN=BI;UID=biuser;PWD=x;', fDriverCompletion=0
[0.000]DSN info:
DSN='BI',server='localhost',port='5432',dbase='BI',user='biuser',passwd='x'
[0.000]
onlyread='0',protocol='7.4',showoid='
Hello!
I have a problem. I try to install PostgreSQL from source with java. I
Installed JDK, ANT properly but when i try to configure i have an error -
Warning.Ignored options - --with-java. Please help me !
[EMAIL PROTECTED] /]# export|grep java
declare -x JAVA_HOME="/usr/java/jdk1.6.0_03"
decl
Hi all,
I noticed in the 8.3 release notes that ARRAY(SELECT ...) now returns
an empty array if there are no rows returned by the subquery.
Until reading this, I didn't even realise that empty arrays were
possible, since ARRAY[] causes a syntax error. I played around with
the array input syntax
On Mon, Nov 26, 2007 at 03:51:37AM +1100, Brendan Jurd wrote:
> Hi all,
>
> I noticed in the 8.3 release notes that ARRAY(SELECT ...) now returns
> an empty array if there are no rows returned by the subquery.
This has come up before, Tom had an idea about how to fix it:
http://groups.google.com
On Sun, 25 Nov 2007, Никоноров Григорий wrote:
I have a problem. I try to install PostgreSQL from source with java. I
Installed JDK, ANT properly but when i try to configure i have an error -
Warning.Ignored options - --with-java. Please help me !
Starting with the 8.0 release the JDBC driv
I'd expect this:
\copy tablename from 'filename.csv' WITH NULL as '' CSV HEADER
whould import "" as NULL.
The input file is UTF-8 (not Unicode/UTF-16).
I checked the hexdump and the "wannabe" NULL are actually
2c 22 22 2c -> ,"",
all fields are varchar that admit NULL
but still I get empty str
s.postgresql.org/
______ NOD32 2684 (20071125) Information __
This message was checked by NOD32 antivirus system.
http://www.eset.com
--
Отправлено M2, революционной почтовой программой Opera:
http://www.opera.com/mail/
---(end of broadcast)-
On Thu, 2007-11-22 at 09:48 +0100, Reg Me Please wrote:
> I have to take into account the update history of every single
> field into a number of tables.
> Those updates can come to the future (next values) but also to the
> past (history fix) and apply only to some fields, usually not to the
> ent
Никоноров Григорий wrote:
> Hi Kris
>
> Thanks for your answer.When i download this "JDBC4 Postgresql Driver,
> Version 8.2-506" driver what should i do next to configure PostgreSQL
> with it ?
there is nothing you need on the backend side (except for maybe setting
up authentication as with every
it ?
there is nothing you need on the backend side (except for maybe setting
up authentication as with every other client).
Stefan
---(end of broadcast)---
TIP 6: explain analyze is your friend
______ NOD32 2684 (20071125) Information
Is there such a thing as an opensource schema printer for postgres ?
Dave.
begin:vcard
fn:David Potts
n:Potts;David
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Sunday 25 November 2007 1:32 pm, Dave Potts wrote:
> Is there such a thing as an opensource schema printer for postgres ?
>
> Dave.
See Autodoc at:
http://www.rbt.ca/autodoc/
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: Have
Hi people,
Does anyone here have replication setup? We're intending to move onto
Postgres and I'm looking into the replication methods available to
us.
We intend to have a master and slave on site and another slave at our
second site down a 10Mb line.
So far the only methods I see would be usabl
Please post errors and your full environment configurationJDK versionJRE
version (if different)
This would be a good time to look into loggers specifically either
commons-logging or log4j
Martin__Disclaimer and
confidentiality noteEverything in this
On 11/25/07, Glyn Astill <[EMAIL PROTECTED]> wrote:
> So far the only methods I see would be usable for us are Slony I and
> WAL log shipping.
WAL shipping probably does not work the way you think it does. The
secondary server that receives the log pieces is not actually able to
serve any queries;
On Nov 25, 2007 3:32 PM, Dave Potts <[EMAIL PROTECTED]> wrote:
> Is there such a thing as an opensource schema printer for postgres ?
http://schemaspy.sourceforge.net/
Creates nice html pages and graphics for many database flavors. Uses Java/JDBC.
---(end of broadcast)---
Hello!
Since the pg_filedump utility manages only the database file I'm currently
writing a pg_xlog/pg_clog viewer.
I'm looking for the documentation in:
// See src/include/access/xlog.h
// See src/include/access/xlog_internal.h
// See src/include/access/xlogdefs.h
// See src/backend/access/tr
On Sun, 2007-11-25 at 23:38 +0100, Alexander Staubo wrote:
> On 11/25/07, Glyn Astill <[EMAIL PROTECTED]> wrote:
> > So far the only methods I see would be usable for us are Slony I and
> > WAL log shipping.
>
> WAL shipping probably does not work the way you think it does. The
> secondary server
On Sun, 2007-11-25 at 22:18 +, Glyn Astill wrote:
> So far the only methods I see would be usable for us are Slony I and
> WAL log shipping.
>
> Does anyone here have a similar setup or any recommendations?
This link may be of some use
http://www.2ndquadrant.com/replication.html
plus 2ndQu
27 matches
Mail list logo
