On Tue, 1 Dec 2009 11:39:06 +0900
Schwaighofer Clemens wrote:
> On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo
> 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 is:
> > - make a backup
> > - load it in a de
On Tue, Dec 1, 2009 at 1:52 AM, raf 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
> client
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
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 postgresq
On 1 Dec 2009, at 11:00,
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; cancelled
>
> I have disabled my AV and I h
May you try to de-install AV & try to take a dump ?
Thanks
Dhaval
--- On Tue, 1/12/09, a.bhattacha...@sungard.com
wrote:
From: a.bhattacha...@sungard.com
Subject: [GENERAL] WARNING: worker took too long to start; cancelled on VACCUM
ANALYZE
To: pgsql-general@postgresql.org
Date: Tuesday,
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 hap
On Tue, 1 Dec 2009 09:53:12 +0100
Ivan Sergio Borgonovo wrote:
> On Tue, 1 Dec 2009 11:39:06 +0900
> Schwaighofer Clemens wrote:
>
> > On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo
> > wrote:
> > > I need to create a new schema with all the content in an
> > > existing one, just with a
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: Tue
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 o
Glyn Astill 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 pgsql-general mailing
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 for
2009/11/30 rahimeh khodadadi :
>
>
> -- Forwarded message --
> From: rahimeh khodadadi
> Date: 2009/11/29
> Subject: Re: psql+krb5
> To: Denis Feklushkin
Please review the guidelines for reporting a problem, which you can find here:
http://wiki.postgresql.org/wiki/Guide_to_repor
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
> thro
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 of
--- On Tue, 1/12/09, Tom Lane 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.
--
Sent via
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 Open
On Tue, Dec 1, 2009 at 7:52 AM, Howard Cole 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 target machine activ
Except that he posted a month ago and got no answers...
On Tue, Dec 1, 2009 at 8:22 AM, Robert Haas wrote:
> 2009/11/30 rahimeh khodadadi :
>>
>>
>> -- Forwarded message --
>> From: rahimeh khodadadi
>> Date: 2009/11/29
>> Subject: Re: psql+krb5
>> To: Denis Feklushkin
>
> Pleas
On Tue, Dec 1, 2009 at 13:52, Howard Cole 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 target machine activel
Adrian Klaver 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 store dates as da
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. Thi
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 do
On Tue, 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 o
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
On Tue, Dec 1, 2009 at 11:26 AM, Scott Marlowe 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:
http://www.postgresql.org/mailpref/pgsql-gene
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 dr
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: pgsql-general-ow
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 of
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 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
> websites. As it sta
On Tue, Dec 1, 2009 at 2:58 PM, Steve Atkins 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
> modern v
On 2009-12-01, 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; each file h
2009/12/1 Rüdiger Sörensen :
> 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 o
Richard Broersma wrote:
On Tue, Dec 1, 2009 at 7:52 AM, Howard Cole 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
Dave Page wrote:
> On Tue, Dec 1, 2009 at 1:52 AM, raf 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 ab
- "Tom Lane" wrote:
> Adrian Klaver 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
> -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
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 subscrip
- "Le-shin Wu" 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 past
> -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
>
> 200
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 fine
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, oth
On Tue, Dec 1, 2009 at 21:39, Howard Cole 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 correct. But
Israel Brewster 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 are arch-sensitive. You
On 2/12/2009 7:10 AM, raf wrote:
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 module fai
* 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
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 execut
On 12/02/2009 06:59 AM, Craig Ringer wrote:
On 2/12/2009 7:10 AM, raf wrote:
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
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 ob
* 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 ou
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 wrote:
> * Craig Ringer (cr...@postnewspapers.com.au) wro
You can also use LISTEN/NOTIFY.
On Tue, Dec 1, 2009 at 6:25 PM, Bret 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
>> To: pgsql-general General
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?
Regard
On Wed, Dec 2, 2009 at 08:16, Helio Campos Mello de Andrade
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 recreate your data
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
wrote:
> Hi guys,
>
> - I'm having a problem when i want to make a backup of my system.
> - Postgres gene
58 matches
Mail list logo
