On Tue, 1 Dec 2009 11:39:06 +0900
Schwaighofer Clemens clemens.schwaigho...@tequila.jp wrote:
On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I need to create a new schema with all the content in an existing
one, just with a new name.
The way I've found
On Tue, Dec 1, 2009 at 1:52 AM, raf r...@raf.org wrote:
hi,
i just tried to upgrade libpq.dll on windows and couldn't
work out how to do it. in the past, with 8.3.x, i knew i had
to download the entire server even though i only wanted
the client but at least i was able to install just the
On 1 Dec 2009, at 4:55, Craig Ringer wrote:
On 1/12/2009 11:33 AM, Greg Smith wrote:
Craig Ringer wrote:
I assume you look up the associated backend by looking up the source
IP and port of the client with `netstat', `lsof', etc, and matching
that to pg_stat_activity?
There's a bunch of ways
Hi All,
I am facing the below error when executing VACCUM ANALYZE on the
several tables and also the entire PostgreSQL database hanging up and
not responding.
WARNING: worker took too long to start; cancelled
I have disabled my AV and I have the modified the below parameters in
my
On 1 Dec 2009, at 11:00, a.bhattacha...@sungard.com
a.bhattacha...@sungard.com wrote:
Hi All,
I am facing the below error when executing VACCUM ANALYZE on the
several tables and also the entire PostgreSQL database hanging up and
not responding.
WARNING: worker took too long to start;
May you try to de-install AV try to take a dump ?
Thanks
Dhaval
--- On Tue, 1/12/09, a.bhattacha...@sungard.com a.bhattacha...@sungard.com
wrote:
From: a.bhattacha...@sungard.com a.bhattacha...@sungard.com
Subject: [GENERAL] WARNING: worker took too long to start; cancelled on VACCUM
Harald Armin Massa wrote:
in 2003 there was a thread started by Hans about dblink_ora...
http://archives.postgresql.org/pgsql-hackers/2003-06/msg00361.php
it ends with something about propably not ready for 7.4.
There was the proposal to integrate it within the normal dblink.
Did happen
On Tue, 1 Dec 2009 09:53:12 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
On Tue, 1 Dec 2009 11:39:06 +0900
Schwaighofer Clemens clemens.schwaigho...@tequila.jp wrote:
On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I need to create a new
I think I'm just going to have to run the priority DB on a different server
(linux) to make sure it doesn't get abused. I can see no other way.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alban Hertroys
Sent:
Hi Chaps,
I'm doing my usual pull-the-plug tests on some new servers, and I'm seeing this
in the logs during redo. Is this in any way normal? I'm guessing it is because
it's just under LOG rather than something like WARNING, but I'm not taking
any chances.
I've got disk caches off, fsync on
Glyn Astill glynast...@yahoo.co.uk writes:
I'm doing my usual pull-the-plug tests on some new servers, and I'm
seeing this in the logs during redo. Is this in any way normal?
Quite, this is one of the expected ways to detect end-of-WAL.
regards, tom lane
--
Sent via
Hi,
I use OpenOffice Base as the front end tool to connect a postgreSQL server.
It works great. But when I am trying to create a table by copying data from
OpenOffice Calc and then pasting to my postgreSQL database (connected
through OpenOffice base), I always got an invalid input syntax error
2009/11/30 rahimeh khodadadi rahimeh.khodad...@gmail.com:
-- Forwarded message --
From: rahimeh khodadadi rahimeh.khodad...@gmail.com
Date: 2009/11/29
Subject: Re: psql+krb5
To: Denis Feklushkin denis.feklush...@gmail.com
Please review the guidelines for reporting a
On Tuesday 01 December 2009 7:21:45 am Le-shin Wu wrote:
Hi,
I use OpenOffice Base as the front end tool to connect a postgreSQL server.
It works great. But when I am trying to create a table by copying data from
OpenOffice Calc and then pasting to my postgreSQL database (connected
through
I am getting many entries in my log of this type:
2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection
2009-12-01 00:13:19 GMTLOG could not receive data from client: No
connection could be made because the target machine actively refused it.
I tend to get these message in batches
--- On Tue, 1/12/09, Tom Lane t...@sss.pgh.pa.us wrote:
I'm doing my usual pull-the-plug tests on some new
servers, and I'm
seeing this in the logs during redo. Is this in any
way normal?
Quite, this is one of the expected ways to detect
end-of-WAL.
Excellent, thanks Tom.
--
On Tuesday 01 December 2009 7:40:26 am Adrian Klaver wrote:
On Tuesday 01 December 2009 7:21:45 am Le-shin Wu wrote:
Hi,
I use OpenOffice Base as the front end tool to connect a postgreSQL
server. It works great. But when I am trying to create a table by copying
data from OpenOffice
On Tue, Dec 1, 2009 at 7:52 AM, Howard Cole howardn...@selestial.com wrote:
I am getting many entries in my log of this type:
2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection
2009-12-01 00:13:19 GMTLOG could not receive data from client: No connection
could be made because the
Except that he posted a month ago and got no answers...
On Tue, Dec 1, 2009 at 8:22 AM, Robert Haas robertmh...@gmail.com wrote:
2009/11/30 rahimeh khodadadi rahimeh.khodad...@gmail.com:
-- Forwarded message --
From: rahimeh khodadadi rahimeh.khodad...@gmail.com
Date:
On Tue, Dec 1, 2009 at 13:52, Howard Cole howardn...@selestial.com wrote:
I am getting many entries in my log of this type:
2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection
2009-12-01 00:13:19 GMTLOG could not receive data from client: No connection
could be made because the
Adrian Klaver akla...@comcast.net writes:
The problem is that dates in spreadsheets are stored as days from some
date. For a more complete answer see:
http://www.lexicon.net/sjmachin/xlrd.html
Somebody should file a bug/RFE against OpenOffice, suggesting that there
ought to be an option to
Hi Adrian,
Thanks for your information. I think your suggestion will be my last
approach, if I really can not find a way to solve my problem. Actually, I
tried to format the cells type (the date column in my sheet) in Calc as
Date before I copy and past, but somehow it works for only once. This
Hi List,
not another question on how to store files (db or filesystem), i decided to use
the filesystem.
I'm now searching for a trigger, that deletes the physical file when deleting a
database-record containing the filename in one of its fields. Is there a sample
somewhere how this could be
On Tue, Dec 1, 2009 at 9:19 AM, Ludwig Kniprath lud...@kni-online.de wrote:
Hi List,
not another question on how to store files (db or filesystem), i decided to
use the filesystem.
I'm now searching for a trigger, that deletes the physical file when deleting
a database-record containing
On Dec 1, 2009, at 9:19 AM, Ludwig Kniprath wrote:
Hi List,
not another question on how to store files (db or filesystem), i decided to
use the filesystem.
I'm now searching for a trigger, that deletes the physical file when deleting
a database-record containing the filename in one of
On Tue, Dec 1, 2009 at 11:26 AM, Scott Marlowe scott.marl...@gmail.com wrote:
Except that he posted a month ago and got no answers...
Gee, I wonder why.
...Robert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Greetings,
I have a PostgreSQL 8.3.7 database that gets backed up each night with
pg_dump -Fc. When I restored it today I got the following:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2021; 2606 20719 CONSTRAINT
last_run_id_key
Never mind. I had my appserver up, and it probably screwed up.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683E-Mail: l...@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-Original Message-
From:
dear all,
I am building a database that will be really huge and grow rapidly. It
holds data from satellite observations. Data is imported via a java
application. The import is organized via files, that are parsed by the
application; each file hods the data of one orbit of the satellite.
One
On Dec 1, 2009, at 1:34 AM, Rüdiger Sörensen wrote:
dear all,
I am building a database that will be really huge and grow rapidly. It holds
data from satellite observations. Data is imported via a java application.
The import is organized via files, that are parsed by the application;
On Fri, Nov 27, 2009 at 6:04 AM, Thom Brown thombr...@gmail.com wrote:
I'm wondering if anyone has experience of storing and getting images to and
from a database? We currently have the problem of images being uploaded to
a single gateway used by many companies, most of which run several
On Tue, Dec 1, 2009 at 2:58 PM, Steve Atkins st...@blighty.com wrote:
For the bulk imports of old data, import the data first, then build the
indexes and add constraints later. Disable autovacuum during the initial bulk
import. Also, consider turning fsync off for those imports (less of a win
On 2009-12-01, Rüdiger Sörensen r.soeren...@mpic.de wrote:
dear all,
I am building a database that will be really huge and grow rapidly. It
holds data from satellite observations. Data is imported via a java
application. The import is organized via files, that are parsed by the
2009/12/1 Rüdiger Sörensen r.soeren...@mpic.de:
dear all,
I am building a database that will be really huge and grow rapidly. It holds
data from satellite observations. Data is imported via a java application.
The import is organized via files, that are parsed by the application; each
file
Richard Broersma wrote:
On Tue, Dec 1, 2009 at 7:52 AM, Howard Cole howardn...@selestial.com wrote:
I am getting many entries in my log of this type:
2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection
2009-12-01 00:13:19 GMTLOG could not receive data from client: No connection
Dave Page wrote:
On Tue, Dec 1, 2009 at 1:52 AM, raf r...@raf.org wrote:
hi,
i just tried to upgrade libpq.dll on windows and couldn't
work out how to do it. in the past, with 8.3.x, i knew i had
to download the entire server even though i only wanted
the client but at least i was
- Tom Lane t...@sss.pgh.pa.us wrote:
Adrian Klaver akla...@comcast.net writes:
The problem is that dates in spreadsheets are stored as days from
some
date. For a more complete answer see:
http://www.lexicon.net/sjmachin/xlrd.html
Somebody should file a bug/RFE against OpenOffice,
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins
Sent: Tuesday, December 01, 2009 9:44 AM
To: pgsql-general General
Subject: Re: [GENERAL] Synchronize filenames in table with filesystem
On Dec 1,
Howard Cole wrote:
Interesting what Francis says about the pool connections being closed
before disposal.
Apologies Francisco
Presumably I should never get this error if I use Npgsql?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
- Le-shin Wu les...@gmail.com wrote:
Hi Adrian,
Thanks for your information. I think your suggestion will be my last
approach, if I really can not find a way to solve my problem.
Actually, I tried to format the cells type (the date column in my
sheet) in Calc as Date before I copy and
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Tuesday, December 01, 2009 2:10 PM
To: r.soeren...@mpic.de
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] optimizing advice
2009/12/1
I am trying to create a static, universal (x86 and ppc at least - 64 bit architectures are optional) build of the PostgreSQL libraries on a Mac OS X 10.6 machine. The command line I am using is as follows:CFLAGS="-arch i386 -arch ppc -arch x86_64" ./configure --disable-sharedThe configure runs
I've dropped all your cross-posts; this is just going to PgSQL-general.
On 30/11/2009 3:29 PM, rahimeh khodadadi wrote:
psql: *krb5_sendauth: Bad application version was sent (via sendauth)*
Have you verified that your Kerberos setup is otherwise working
correctly - it's handling logins,
On Tue, Dec 1, 2009 at 21:39, Howard Cole howardn...@selestial.com wrote:
Howard Cole wrote:
Interesting what Francis says about the pool connections being closed
before disposal.
Apologies Francisco
:) No problem.
Presumably I should never get this error if I use Npgsql?
That's
Israel Brewster isr...@frontierflying.com writes:
I am trying to create a static, universal (x86 and ppc at least - 64
bit architectures are optional) build of the PostgreSQL libraries on a
Mac OS X 10.6 machine.
I think what you're missing is that the header files generated by
configure
On 2/12/2009 7:10 AM, raf wrote:
aside
not only that, but on a windows host on which i had
installed the 8.3 client and server software, when i
uninstalled the server leaving the client software behind,
the client software was no longer complete and couldn't
be used (i.e. python's pygresql
* Craig Ringer (cr...@postnewspapers.com.au) wrote:
I've dropped all your cross-posts; this is just going to PgSQL-general.
Thanks for that.
On 30/11/2009 3:29 PM, rahimeh khodadadi wrote:
psql: *krb5_sendauth: Bad application version was sent (via sendauth)*
Also: a search for your error
Dear all,
I am using the archive binary(8.4.1 Linux x64) from
EnterpriseDBhttp://www.enterprisedb.com/products/pgbindownload.dofor
the installation. Basically I just unzipping the binary under
/home/app/, so i have the following directory structure
/home/app/pgsql
I noticed that i need to
On 12/02/2009 06:59 AM, Craig Ringer wrote:
On 2/12/2009 7:10 AM, raf wrote:
aside
not only that, but on a windows host on which i had
installed the 8.3 client and server software, when i
uninstalled the server leaving the client software behind,
the client software was no longer complete and
Craig Ringer wrote:
On 1/12/2009 11:33 AM, Greg Smith wrote:
1) If you spawn the psql process with bash using , you can then find
its pid with $!, then chain through the process tree with ps and
pg_stat_activity as needed to figure out the backend pid.
I feel like I'm missing something
* Greg Smith (g...@2ndquadrant.com) wrote:
Craig Ringer wrote:
On 1/12/2009 11:33 AM, Greg Smith wrote:
1) If you spawn the psql process with bash using , you can then find
its pid with $!, then chain through the process tree with ps and
pg_stat_activity as needed to figure out the backend
On 2/12/2009 10:40 AM, Sachin Srivastava wrote:
Dave: Are there sources available for the EnterpriseDB
installer/packaging system? I'd like to get into the linux library
path patcking problem myself, since nobody at EDB seemed to be
interested in the issues when discussed on -general last week.
On 12/02/2009 09:42 AM, Craig Ringer wrote:
On 2/12/2009 10:40 AM, Sachin Srivastava wrote:
Dave: Are there sources available for the EnterpriseDB
installer/packaging system? I'd like to get into the linux library
path patcking problem myself, since nobody at EDB seemed to be
interested in the
I thanks from Stephen and Craig for their replying.
I am sorry for doing cross posting, But I did not know about it before. I
had to do for solving the problem, because no one did me answer .
On Wed, Dec 2, 2009 at 5:15 AM, Stephen Frost sfr...@snowman.net wrote:
* Craig Ringer
You can also use LISTEN/NOTIFY.
On Tue, Dec 1, 2009 at 6:25 PM, Bret bret_st...@machinemanagement.com wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins
Sent: Tuesday, December 01, 2009 9:44 AM
Hi guys,
- I'm having a problem when i want to make a backup of my system.
- Postgres generated dump was created out of foreing key order and when i
try to recreate my database structures, data and functions. Does someone
have this same issue? Someone knows of some app that do the job?
On Wed, Dec 2, 2009 at 08:16, Helio Campos Mello de Andrade
helio.cam...@gmail.com wrote:
- Postgres generated dump was created out of foreing key order and when i
try to recreate my database structures, data and functions.
I think there's some information missing here.
What happens when you
pg_dump dumps data first and then the constraints (including FK) so
there shouldn't be any problems when you import the dump.
On Wed, Dec 2, 2009 at 2:16 AM, Helio Campos Mello de Andrade
helio.cam...@gmail.com wrote:
Hi guys,
- I'm having a problem when i want to make a backup of my
58 matches
Mail list logo