Thank you for the explanation. We shall try the latest PostgreSQL 9.6.6
version.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
Michael, Thanks for your reply, I found the issue, the person who setup OS
mix up some 64 and 32 bit package. I am starting it again.
Thanks again.
On Fri, Aug 21, 2015 at 5:12 PM, Michael Paquier
wrote:
>
>
> On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal
> wrote:
>
>> 2015-08-21 15:35:03 IST
On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal
wrote:
> 2015-08-21 15:35:03 IST [21507-2] DETAIL: The primary's identifier is
> 6185381639353264094, the standby's identifier is 6185382953613258663.
>
> It gives the error "database system identifier differs between the primary
> and standby".
>
T
Detailed logs in log file
DETAIL: The primary's identifier is 6185381639353264094, the standby's
identifier is 6185382953613258663.
2015-08-21 15:34:16 IST [21447-1] FATAL: database system identifier
differs between the primary and standby
2015-08-21 15:34:16 IST [21447-2] DETAIL: The primary's
Hi Álvaro,
Pardon my stupidity. I kept looking for things in the wrong place. The
pg_toast tables have always been there, I was just issuing the commands yo
mentioned in a different database. Need to get more sleep. xD
In the end, we decided the entire database needed a good cleaning. So we
sched
Hi Erik,
I thouht pg_cancel_backend and pg_terminate_backend simply send SIGINT and
SIGTERM, respectively, to the backend process? We did try using the commands
and sending the signals ourselves, but to no avail.
--
View this message in context:
http://postgresql.nabble.com/postgresql-9-3-5-au
Peter Eisentraut-2 wrote
> On 5/29/14, 11:59 AM, Bob Moyers wrote:
>> When I try this update:
>>
>> UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE
>> (REPORT_STYLE_NAME = ?)
>>
>>
>>
>> I get:
>>
>> org.postgresql.util.PSQLException: ERROR: invalid XML content
>>
>> Detail
On 5/29/14, 11:59 AM, Bob Moyers wrote:
> When I try this update:
>
> UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE
> (REPORT_STYLE_NAME = ?)
>
>
>
> I get:
>
> org.postgresql.util.PSQLException: ERROR: invalid XML content
>
> Detail: line 2: StartTag: invalid element nam
I have this table:
CREATE TABLE REPORT_STYLE (
REPORT_STYLE_NAME VARCHAR(75) NOT NULL,
REPORT_STYLE_VERSION NUMERIC(8,0) NOT NULL,
UPDATE_TS TIMESTAMP NOT NULL,
UPDATE_USER_NAME VARCHAR(30) NOT NULL,
STYLE_DESCR VARCHAR(200),
JASPER_STYLE XML
);
ALTER TABLE REPORT_STYLE ADD
I'll probably ask @pgbouncer mailing list if i can use it with
advisory_locks per session. If not, even raw sessions will be enough.
Some comments inline.
Thanks
On Sun, Apr 27, 2014 at 10:07 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Dorian Hoxha wrote
> > Hi list,
> >
> > I am
Dorian Hoxha wrote
> Hi list,
>
> I am trying to use postgresql as a queue for long-jobs (max ~4 hours)
> using
> advisory_locks. I can't separate the long-job into sub-jobs.
>
>
>1. At ultimate-best-case scenario there will be ~100 workers, so no
>web-scale performance required.
>Is
On 01/29/2014 08:03 PM, Florian Weimer wrote:
> On 01/29/2014 09:07 AM, Craig Ringer wrote:
>
>> A challenge I've found when approaching this from the ORM side has been
>> getting people to care. The sentiment has tended to be along the lines
>> of: No other DBMS does this or requires this, why do
Florian Weimer wrote:
> Can you use other JDBC drivers (except SQLite) to insert
> Java Strings into NUMERIC columns and Java ints into text
> columns?
The JDBC specification can be downloaded from here:
http://download.oracle.com/otndocs/jcp/jdbc-4_1-mrel-spec/index.html
Check out appendix B.
On 01/29/2014 12:07 AM, Craig Ringer wrote:
On 01/29/2014 02:36 PM, David Johnston wrote:
The "correct" solution would seem to be for ORMs to "bind unknown" against
the input but only when the supplied string is meant to be a representation
of a PostgreSQL type as opposed to being actual string
On Wed, Jan 29, 2014 at 2:07 AM, Craig Ringer wrote:
> On 01/29/2014 02:36 PM, David Johnston wrote:
>>
>> The "correct" solution would seem to be for ORMs to "bind unknown" against
>> the input but only when the supplied string is meant to be a representation
>> of a PostgreSQL type as opposed to
On 01/29/2014 09:07 AM, Craig Ringer wrote:
A challenge I've found when approaching this from the ORM side has been
getting people to care. The sentiment has tended to be along the lines
of: No other DBMS does this or requires this, why do we have to jump
through hoops just to make PostgreSQL ha
On 01/29/2014 02:36 PM, David Johnston wrote:
>
> The "correct" solution would seem to be for ORMs to "bind unknown" against
> the input but only when the supplied string is meant to be a representation
> of a PostgreSQL type as opposed to being actual string data. The ORM is free
> to provide the
Tom Lane-2 wrote
> Craig Ringer <
> craig@
> > writes:
>> I just want us to allow, by default, implicit casts FROM text (not TO
>> text) using the input function for all PostgreSQL's validated
>> non-standard types (and XML due to limited deployment of SQL/XML support
>> in client drivers).
>
>
Aftab Ahmed Chandio wrote
> I found 85 ms time unit in DOS (win7) (laptop 4cores). both Java and
> PostgreSQL installed and invoked on the same machine, respectively.
> On the other hand, I use same process (separate installation) on linux on
> 8 cores physical machine with 2times greater then lapt
If you failed to solve your problem after following below 2 links,
http://1stopit.blogspot.dk/2011/01/postgresql-83-and-84-fails-to-install.html
http://igordcard.blogspot.dk/2012/03/unable-to-write-inside-temp-environment.html
try following last solution which will 100% work: (in my case it worke
I am very confused after I read the guide as follows. It means I only need
to set the search_path to make the pg_temp as the last entry. or I need
configure search_path and at the same time, I need create the security
definer? Is thers anybody help me?
Thank you very much. I really appreciate i
I did a bit of looking around in the jdbc driver and found this method
in: org.postgresql.jdbc2.TypeInfoCache
public int getPrecision(int oid, int typmod) {
oid = convertArrayToBaseOid(oid);
switch (oid) {
...
case Oid.TEXT:
case Oid.BYTEA:
I have postgresql 8.3.9 install on my server, this service run with user
postgres and it start well
On Wed, Jan 26, 2011 at 3:58 PM, tuanhoanganh wrote:
> Yesterday, my postgresql 9.0 service run well with user postgres. But today
> when it start, it have error "The service did not respond to
Hi,
I have tried initdb manually, it failed:
initdb -D "D:\\Amber\\Program\\PostgreSQL\\9.0\\data"
--lc-messages=English -U postgres E UTF8 -A md5
and unfortunately initdb can't show the error messages probably, I
think it is because of encoding, my notebook is in Simplified Chinese
Locale, and I
On Sun, Sep 27, 2009 at 11:18 AM, Sam Mason wrote:
> On Sun, Sep 27, 2009 at 06:05:51PM +0200, Gerhard Wiesinger wrote:
>> A google research has shown that Gregory Stark already worked on that issue
>> (see references below) but as far as I saw only on bitmap heap scans.
>
> Greg Stark's patches a
On Jul 20, 9:29 am, dmag...@gmail.com (Chris) wrote:
> > *I have tried *RubyRep, Bucardo, *_but none of these have a stable rpm
> > release for CentOS version of Linux Operation System_.
Just to mention this: rubyrep comes with a bundled package.
http://www.rubyrep.org/installation.html
Just u
Bruce Momjian wrote:
Added to TODO:
* Allow XML to accept more liberal DOCTYPE specifications
Is any form of DOCTYPE accepted?
We're getting errors on the second line like this:
http://host.domain/dtd/dotdisposition0_02.dtd";>
The actual host.domain value is resolved by DNS,
and wget of th
Bruce Momjian wrote:
Added to TODO:
* Allow XML to accept more liberal DOCTYPE specifications
Is any form of DOCTYPE accepted?
We're getting errors on a second line in an XML document that
starts like this:
http://host.domain/dtd/dotdisposition0_02.dtd";>
The actual host.domain value is re
Bruce Momjian wrote:
Added to TODO:
* Allow XML to accept more liberal DOCTYPE specifications
Is any form of DOCTYPE accepted?
We're getting errors on the second line like this:
http://host.domain/dtd/dotdisposition0_02.dtd";>
The actual host.domain value is resolved by DNS,
and wget of th
Where can i download the postgresql-7.4-3 release for ppc64 ?. What
postgresql release is compatible for this kind of arquitecture ?.
If you don't receive an immediate response, you don't need to repost
your question.
You'll need to download it and compile it yourself:
http://www.postgresql
Title: RE: Postgresql over ppc4 °
_
De: Ivan Israel Azuara Hernandez
Enviado el: Viernes, 17 de Marzo de 2006 09:26 p.m.
Para: 'pgsql-general@postgresql.org'
CC: Ivan Israel Azuara Hernandez
Asunto: Postgresql over ppc4 °
Im
Andy Burns <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> why not run VMWare on NT4/W2K on the laptop, then run linux inside the
> virtual machine and run PGSQL there, you sacrifice some speed, but are
> running PGSQL on a real O/S that it is designed to run on, not
> shoehorn
Nils Zonneveld <[EMAIL PROTECTED]> wrote:
> I'm searching for a web hosting company that also supports PostgreSQL
> and that is based in the Netherlands. Does anyone know a good one?
Ones that I'm aware of are
- Business Internet Trends, http://www.bit.nl
- Cistron Internet Services, http://www.c
Sami wrote:
>
> > The insert statement executed from php is:
> > >
> > > $otsikko = "Insert testi";
> > > $teksti = "Koeteksti 1";
> > >
> > > $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
> > > $sqllause = $sqllause . $otsikko . "','" . $teksti . "');";
Hmmm...
> The insert statement executed from php is:
> >
> > $otsikko = "Insert testi";
> > $teksti = "Koeteksti 1";
> >
> > $sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
> > $sqllause = $sqllause . $otsikko . "','" . $teksti . "');";
>
> Have you tried without the ";"?
> In the table, you're storing the OID of the large object itself, so if you
> copy all the contents of the table, so far as I can see, yes, you'd still
> have the reference to your large object.
Thanks. I did see this in a quick test, but I wasn't sure if the data would
be removed when I droppe
On Fri, 4 May 2001, David Wall wrote:
> Sorry to bother you personally, but I read your "Updating columns in PostgreSQL
>tables effectively" page and had a question.
>
> Will the temporary table scheme work if the table contains blobs (identified by
>OIDs)? In my case, I don't need to preserv
On Mon, 9 Apr 2001, Steve Jorgensen wrote:
Check your path to make sure that cygipc is in it. IIRC, configure is
looking for libcygipc, and probably not finding it.
> $ ./configure
> creating cache ./config.cache
> checking host system type... i686-pc-cygwin
> checking which template to use... w
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>I'm running postgresql-7.0.2-6 on a Debian potato.
Any particular reason why you're not running 7.0.3 (which is the latest
release and contains fixes for some problems with 7.0.2)?
Ray
--
"People should never have been given free will." Lots of lan
will trillich wrote:
>On Wed, Feb 28, 2001 at 06:52:01AM +, Oliver Elphick wrote:
>> A pity the dump file got clobbered.
>
>indeed!
>
>> I suspect the dump from 6.5 was
>> in a form that 7.0 rejected - you had those two failed creates in the
>> log.
>
>the problem was appar
will trillich wrote:
>> >-rw---1 postgres postgres 8192 Feb 27 04:00 range
>> >-rw---1 postgres postgres16384 Feb 11 07:39 range_pkey
>> >actually, i think the 'range' table is the main one i need to
>> >resurrect... everything else is gravy.
>>
>> Wha
Oliver Elphick wrote:
> will trillich wrote:
> >-rw---1 postgres postgres4 Feb 27 12:24 PG_VERSION
> >-rw---1 postgres postgres0 Oct 13 21:05 active
> >-rw---1 postgres postgres 8192 Feb 27 04:00 cust
> >-rw---1 postgres postgres16384
Aah! Life is so good when things are working.
Thanks very much.
Regards,
Bill
--- "Trewern, Ben" <[EMAIL PROTECTED]> wrote:
> Mandrake 7.2 includes tcl-8.3.2-4mdk. Make sure
> this is installed then, as
> long as thats the only remaining dependency, install
> postgresql-tcl-7.0.3-2mdk with
Oliver Elphick wrote:
>
> will trillich wrote:
> >aha. i found /var/lib/postgresql/data/automatic_update.log
> >containing, among other things:
> >
> >[snip]
> >You are now connected to database template1 as user will.
> >CREATE DATABASE
> >You are now connected to database puz as u
On Fri, Feb 16, 2001 at 09:36:23AM -0500, Bruce Momjian wrote:
>
> Funny you should mention PHP. I talked to Rasmus about the email volume
> when I first met him in the fall. He said the volume of email is so
> great that just reading the subject lines takes a long time.
>
> We aren't there
The license agreements of many commercial DBs forbid licensees from
publishing benchmarks of their software.
What is your undergraduate project? More details could help, anyway most of
the popular RDBMS features are in Postgresql.
I'd figure Postgresql is one of the best RDBMSes to use for an
un
> >> ... I wonder whether this is an inbuilt,
> >> unavoidable problem with free software projects once they reach a certain
> >> level of popularity.
>
> > Funny you should mention PHP. I talked to Rasmus about the email volume
> > when I first met him in the fall. He said the volume of email
On Fri, 16 Feb 2001, Mitch wrote:
> Helpful developers doesn't go near far enough..
>
> I've seen (and still do see) commercial support that isn't up to the grade
> of support I have gotten from the -general and -hackers lists. I can ask any
> question and I *always* get a response within minute
> Yah. What I find is the developers set the general tone/culture of the
list.
> This affects the type of responses/support you get even from the other
list
> subscribers. So it's quite good here where you have kind and helpful
developers.
Helpful developers doesn't go near far enough..
I've see
On Tue, 13 Feb 2001, Paul M Foster wrote:
> Let me echo this. I have _never_ been on a list where so many of the
> developers of a product were subscribed as well. And these folks
> provide _very_ considerate and clear assistance. Hats off to them.
Yah. What I find is the developers set the gener
I've heard of other people running databases on a Netapp Filer
I think this is generally ok because the netapp has a special
write cache in NVram and that's what makes it so fast.
On Fri, 9 Feb 2001, tc lewis wrote:
>
> On Fri, 9 Feb 2001, Shaw Terwilliger wrote:
> > I've been using PostgreSQL
On Fri, 9 Feb 2001, tc lewis wrote:
>
> On Fri, 9 Feb 2001, Shaw Terwilliger wrote:
> > I've been using PostgreSQL for a few years now in various projects, and
> > I've been very happy with its features and performance.
> >
> > I have a client who wants to know how PostgreSQL (7) will perform
On Fri, 9 Feb 2001, Shaw Terwilliger wrote:
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Solaris, the server
El Vie 26 Ene 2001 17:02, Chean Fonk Joe Thong escribió:
> Hi to all,
>
> Currently I'm trying to upgrade my PostgreSQL from 6.5
> to 7.0.2 with rpm files on my Redhat 6.1 with Glibc
> 2.1.3. The installation won't continue because RPM
> Manager told me that I need libc.so.6 (>= GLIBC 2.2).
I ha
On Mon, 08 Jan 2001 19:50:00 Jreniz wrote:
>I´ve a Linux RH6.2 machine with PostgreSQL 6.5.3, this works fine with
>PHP module, but, I need create a GTK client program that sends queries
>to database.
>
>I saw the manuals and documentation but, i don´t know how compile these
>programs, and the man
[EMAIL PROTECTED] writes:
>This is a multi-part message in MIME format...
>
>=_972603822-62422-5
>Content-Type: text/plain
>Content-Disposition: inline
>Content-Transfer-Encoding: binary
>Content-Description: Index
>Mime-Version: 1.0
>X-Mailer: MIME-tools 5.316 (Entity 5.212)
>
>Postg
Oops, sorry!
David
On Thu, 12 Oct 2000, Bruce Momjian wrote:
> > Could you please put the ISBN on the web page:
> > http://www.postgresql.org/docs/awbook.html
> > I know I can get it from Amazon or whatever, but it would save people the
> > extra trip.
>
> Done.
>
> ISBN 0-201-70331-9
>
> >
> > Anyway,
Regarding documentation updates...
Patch updates might work for a "small" quantity of documentation ("small"
in this context, meaning on order of Postgresql documentation), but I just
wanted to relate my experience on large documentation sources with these
types of patches (sort of funny in a sa
---
> From: "Bruce Momjian" <[EMAIL PROTECTED]>
> To: "Louis Bertrand" <[EMAIL PROTECTED]>
> Cc: "Adam Lang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Thursday, October 12, 2000 4:36 PM
> Subj
AIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 4:36 PM
Subject: Re: [GENERAL] Re: PostgreSQL book
> > Could you please put the ISBN on the web page:
> > http://www.postgresql.org/docs/awbook.html
> > I know I can get it from A
At 04:58 PM 10/12/00 -0400, Louis Bertrand wrote:
>Thanks. It helped cheer me up: I'm fighting with MS-Access at the
>moment (and losing badly).
Error Number 3135 There is no message for this error.
:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation
> Thanks. It helped cheer me up: I'm fighting with MS-Access at the
> moment (and losing badly).
I hear you. PostgreSQL has been a very good thing for me, the past few
years. In many ways, it is the _fun_ part of computers.
--
Bruce Momjian| http://candle.pha.pa.us
Thanks. It helped cheer me up: I'm fighting with MS-Access at the
moment (and losing badly).
Ciao
--Louis <[EMAIL PROTECTED]>
Louis Bertrand http://www.bertrandtech.on.ca/
Bertrand Technical Services, Bowmanville, ON, Canada
Tel: +1.905.623.1500 Fax: +1.905.623.3852
OpenBSD: Secure
> Could you please put the ISBN on the web page:
> http://www.postgresql.org/docs/awbook.html
> I know I can get it from Amazon or whatever, but it would save people the
> extra trip.
>
> Anyway, I'm placing the order today with my local bookmonger. The PDF
> printed pages just don't cut it.
> Could you please put the ISBN on the web page:
> http://www.postgresql.org/docs/awbook.html
> I know I can get it from Amazon or whatever, but it would save people the
> extra trip.
Done.
ISBN 0-201-70331-9
>
> Anyway, I'm placing the order today with my local bookmonger. The PDF
Could you please put the ISBN on the web page:
http://www.postgresql.org/docs/awbook.html
I know I can get it from Amazon or whatever, but it would save people the
extra trip.
Anyway, I'm placing the order today with my local bookmonger. The PDF
printed pages just don't cut it.
Thanks!
--Lou
[ Charset ISO-8859-1 unsupported, converting... ]
> Yeah, but I can't sit and read stuff like that on a screen... Granted I can
> print it and get a binder, etc... but stuff like that really is easier in
> publication and as long as the price isn't gouged and the book is good, I
> don't mind forki
ngineer
Rutgers Casualty Insurance Company
- Original Message -
From: "K Parker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 2:48 PM
Subject: [GENERAL] Re: PostgreSQL book
> > It could be just me, but the online docs are
> &
The mailing address in my address book (which is what I generally use):
[EMAIL PROTECTED]
The daily digests I get have the following email address at the top:
[EMAIL PROTECTED]
Both seem to work for me.
- Tim
Richard Brown wrote:
>
>
Hans-Jürgen Schönig wrote:
> When doing multiple insert, please consider the following: PostgreSQL
> uses fsync (I think) after every insert. This is extremely slow when
> inserting large amounts of data at once. On the other hand this helps
> you to protect the database if the systems crashes.
David Steuber <[EMAIL PROTECTED]> writes:
> For perl, using CPAN.pm, what install command will get me the
> interfaces for PostgreSQL? Do I need to have PostgreSQL setup and
> running first?
Before you can use DBI with PostgreSQL, the PostgreSQL database server
must be running on your computer
Sean <[EMAIL PROTECTED]> wrote:
> I am using PostgreSQL version 7.0.2 with RedHat 6.1. When I start up the
> postmaster at the prompt, I get the following response and the session hangs
> and doesn't return to the prompt but I am able to use my databases and
> PostgreSQL. Is this normal or correc
Should work under NT. Check out postgresql.org for instructions.
For NT, the server-side port of Postgres uses RedHat/Cygnus
Cygwin toolset. For Windows 9x, only a client odbc connection
can be made.
Never done odbc calls to an NT postgres server, but I have made odbc request
to a Linux Box w/
>
I don't know the internals of PostgreSQL, but logically INTERSECT is a join, but with
an automatic
default generation of the WHERE clause. As such, there should not be any difference in
performance
on tables that are large enough to mask small differences in the time it takes to
parse the
co
Hello Lincoln,
On 18-Feb-00 05:40:51, you wrote:
>About transactions, I find that they're not that useful in a typical web
>app, because
>1) Many web apps are simple, and don't need transactions, or have simple
>work arounds.
You mean that applications that require almost read only databases,
At 10:10 AM 17-02-2000 +0100, Nemeth Miklos wrote:
>> And if this isn't too inflamatory a question, where does postgresql stand
>> in comparison to MySql and DB2? (both of which aren't free I believe).
>>
>MySQL does NOT support transaction, which is indispensable for a real
>DBMS used as the prim
Nemeth Miklos wrote:
> PostgreSQL supports both transactions and row level locking. Only Oracle
> may compete with PostgreSQL in this area.
InterBase supports both transactions and row-level locking, with a
multigenerational architecture similar to MVCC.
--
Lamar Owen
WGCR Internet Radio
1 Peter
Wow, where do I start with this?
> Bruce> I am talking about the database comparison chart. We said in the past,
> Bruce> "Hey, you don't mention a major feature that every DBMS should have, and
> Bruce> that is transaction/rollback, and they said, "We don't know how to test
> Bruce> for that."
> It would be very nice you could add to the above the features that
> MySQL has that postgreSQL is missing. PostgreSQL does have some
> features that MySQL lacks, but MySQL does support a lot of ODBC and
> ANSI SQL things that postgreSQL doesn't support. We have also put a
> lot of effort in MyS
On 17-Sep-99 The Hermit Hacker wrote:
>
> Tonight, we officially release v6.5.2 for those that have been
> experiencing problems with either v6.5 or v6.5.1. I've created two
> patches, one from 6.5->6.5.1 and one from 6.5.1->6.5.2 ... please let me
> know if there are any problems with them...
I'm forwarding this to the general list, as I haven't used an hp-unix box
before.
Peter
On Wed, 2 Jun 1999, GTI wrote:
> Hi
> I am about to install a PostgreSQL version (6.4.2) on a hp-unix machine.
> My GNU C++ compiler is version 2.8.1, and has been tested so that I know it works.
> Prior t
82 matches
Mail list logo
