I just ported my whole DB instance, 4 db's inside with roles, triggers,
stored procedures, etc... from v8.2.5 to v8.3.4. After the initdb, I
mimiced the mods I had in the postgres.conf and pg_hba.conf files to
v83. Then I used pg_dumpall and psql to do the move. That was far and
away the easiest D
Hi Richard
Thanks for your help. I'll try that.
Darragh
On Wed, Oct 1, 2008 at 6:03 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Darragh Gammell wrote:
> > I am currently upgrading from 8.1 to 8.3 and am getting errors when
> > restoring the dump from 8.1 into 8.3. Like below:
>
> > I have
Dennis Brakhane escribió:
> On Wed, Oct 1, 2008 at 5:54 PM, Reg Me Please <[EMAIL PROTECTED]> wrote:
> > Hi all.
> >
> > Is there a way to have (sub)transactions within a function body?
> > I'd like to execute some code (a transaction!) inside a function and later
> > decide whether that transactio
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe
> Sent: Thursday, 2 October 2008 7:39 AM
> To: Seb
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] inserting only new rows from csv file
>
>
> On Wed, Oct 1, 2008 at 3:16 PM, S
On Wed, 1 Oct 2008 22:19:29 +0200
"Filip Rembiałkowski" <[EMAIL PROTECTED]> wrote:
> > Is this kind of stuff going to affect any reference to the farm
> > table? eg. inside functions, triggers etc?
> no, not in functions source.
I've read somewhere that create *or replace* should be used exactly
On Wed, Oct 1, 2008 at 3:16 PM, Seb <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've seen some approaches to this problem, but I suspect there are
> better ways.
>
> A csv file is produced nightly, with the same table structure as a table
> in a PostgreSQL database. The file grows over time as new record
On Wed, Oct 1, 2008 at 5:54 PM, Reg Me Please <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> Is there a way to have (sub)transactions within a function body?
> I'd like to execute some code (a transaction!) inside a function and later
> decide whether that transaction is to be committed or not.
You coul
Hi,
I've seen some approaches to this problem, but I suspect there are
better ways.
A csv file is produced nightly, with the same table structure as a table
in a PostgreSQL database. The file grows over time as new records are
added every day. However, the rows in the file may not be sorted the
Thanks Tom!
I just tried a query for cooktimes over 1 million to test your theory,
as it would almost instantly be able to tell from the index that there
are zero rows matching that condition. Indeed, it hits the index
which is what I would expect, and the total runtime is 0.163ms.
Thank
2008/10/1 Ivan Sergio Borgonovo <[EMAIL PROTECTED]>:
> On Wed, 01 Oct 2008 08:32:16 -0600
> Bill Thoen <[EMAIL PROTECTED]> wrote:
>
>> CREATE TABLE farm2 (LIKE farms);
>> INSERT INTO farm2 (farm_id, fips_cd, farm_nbr, prog_year) SELECT
>> farm_id, fips_cd, farm_nbr, '2007' FROM farms;
>> DROP TABLE
Sorry to all but my original reply went to Dave instead of the list.
Gauthier, Dave wrote:
Wait, I also appear to have plperlu (createlang plperlu seems to have
worked successfully).
Now if it will do what you need. :-)
Rod
--
-Original Message-
From: Roderick A. Anderson [mailt
Hi:
I need to write a stored function that will perform a complex task which
has already been handled in OO subfunctions of an external perl module.
The perl module has many subroutines and OO constructs and may use
whatever else is legal to use in perl. (I do have the source code for
the perl
Hi all.
Is there a way to have (sub)transactions within a function body?
I'd like to execute some code (a transaction!) inside a function and later
decide whether that transaction is to be committed or not.
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
On Wed, Oct 1, 2008 at 6:23 PM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> I presume it's issuing some sort of commit or rollback without a begin,
> however the programs authors are telling me that's not the case and their
> software is not at fault.
Of course their software can't be at fault, as
> > Ah,
> >
> > It just hit me that I probably logged all the wrong
> type of stuff there. I should have been logging statements
> shouldn't I?
> >
> > http://privatepaste.com/6f1LYISojo
> >
> > I think this shows up that they're sending an
> extra commit transaction on line 36.
> >
> > Could
>
> If you're using connection pooling it's possible
> that the a connection
> is getting reused and a commit is happening there.
>
> It's not an uncommon practice to do a rollback when
> first getting a
> shared connection to make sure it's fresh and clean...
That's interesting to hear.
Alth
In response to Glyn Astill <[EMAIL PROTECTED]>:
> Ah,
>
> It just hit me that I probably logged all the wrong type of stuff there. I
> should have been logging statements shouldn't I?
>
> http://privatepaste.com/6f1LYISojo
>
> I think this shows up that they're sending an extra commit transact
On Wed, Oct 1, 2008 at 10:23 AM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> Hi Chaps,
>
> I'm getting the aforementioned warning in my logs from a closed source piece
> of software. The software helps us convert over some old proprietary data
> files, and it's basically just done a COPY into a new
> > I presume it's issuing some sort of commit or
> rollback without a begin, however the programs authors are
> telling me that's not the case and their software is not
> at fault.
>
> Of course their software can't be at fault, as it is
> entirely bug free ;-)
>
> You could turn on statement l
Ah,
It just hit me that I probably logged all the wrong type of stuff there. I
should have been logging statements shouldn't I?
http://privatepaste.com/6f1LYISojo
I think this shows up that they're sending an extra commit transaction on line
36.
Could someone dous a favour and chack I've not
In response to Glyn Astill <[EMAIL PROTECTED]>:
> Hi Chaps,
>
> I'm getting the aforementioned warning in my logs from a closed source piece
> of software. The software helps us convert over some old proprietary data
> files, and it's basically just done a COPY into a newly created table, afte
Hi Chaps,
I'm getting the aforementioned warning in my logs from a closed source piece of
software. The software helps us convert over some old proprietary data files,
and it's basically just done a COPY into a newly created table, after the
warning it then goes on to create some indexes.
I p
Reg Me Please <[EMAIL PROTECTED]> schrieb:
> Hi all.
>
> Is there a way to have (sub)transactions within a function body?
No.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was
Ya, I aborted it and am successfully restoring the DB using psql. It's
sure taking up cycles and disk space now :-)
-dave
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2008 11:52 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: R
"Gauthier, Dave" <[EMAIL PROTECTED]> writes:
> I'm attempting to restore in v8.3.4 using pg_restore running under
> v8.3.4 using...
> pg_restore -f mydb.pgdump -i -C
> It doesn;t appear to be doing anything.
It's waiting for an archive to show up on stdin :-(
-f is the *output* file name for pg_r
Gauthier, Dave <[EMAIL PROTECTED]> schrieb:
> Hi:
>
>
>
> I did a pg_dump of a v8,2,5 db using...
>
>
>
> pg_dump –C –file=thedb.pgdump thedb
This create a plain text dump.
>
>
>
> I’m attempting to restore in v8.3.4 using pg_restore running under v8.3.4
> using...
>
>
>
> pg_r
In response to "Scott Marlowe" <[EMAIL PROTECTED]>:
> On Wed, Oct 1, 2008 at 7:58 AM, Sergey A. <[EMAIL PROTECTED]> wrote:
> >> Sure it does.
> >>
> >> copy from STDIN
> >> 213 345 567
> >> 847 837 473
> >> \.
> >
> > Thanks. Was this query entered in psql shell?
>
> Yes, but if you're using
Hi:
I did a pg_dump of a v8,2,5 db using...
pg_dump -C -file=thedb.pgdump thedb
I'm attempting to restore in v8.3.4 using pg_restore running under
v8.3.4 using...
pg_restore -f mydb.pgdump -i -C
It doesn;t appear to be doing anything. ps shows no cpu usage. du
shows no increas
On Wed, 01 Oct 2008 08:32:16 -0600
Bill Thoen <[EMAIL PROTECTED]> wrote:
> CREATE TABLE farm2 (LIKE farms);
> INSERT INTO farm2 (farm_id, fips_cd, farm_nbr, prog_year) SELECT
> farm_id, fips_cd, farm_nbr, '2007' FROM farms;
> DROP TABLE farms;
> ALTER TABLE farm2 RENAME TO farms;
> CREATE UNIQUE
Many thanks to everyone who helped me with this. It'll be a while before
I understand enough to be able to do a good job of tuning my system's
configuration, but there seem to be a few basics I can apply right away.
Also pointing out how UPDATE actually works was very helpful. Since I'm
at the
On Wed, Oct 1, 2008 at 8:04 AM, Sergey A. <[EMAIL PROTECTED]> wrote:
>> There is a network API for COPY. Look up pg_put_line (or PQputLine
>> or whatever the convention is for whatever API you're using).
>
> Thanks for your answer. I use Erlang (erlang.org) + pgsql2 (it's
> native Erlang driver ma
On Wed, Oct 1, 2008 at 7:58 AM, Sergey A. <[EMAIL PROTECTED]> wrote:
>> Sure it does.
>>
>> copy from STDIN
>> 213 345 567
>> 847 837 473
>> \.
>
> Thanks. Was this query entered in psql shell?
Yes, but if you're using something like php, you can enter it as a
single string and it will work.
> There is a network API for COPY. Look up pg_put_line (or PQputLine
> or whatever the convention is for whatever API you're using).
Thanks for your answer. I use Erlang (erlang.org) + pgsql2 (it's
native Erlang driver maintained by ejabberd developers). All all I
have is the following functions:
> Sure it does.
>
> copy from STDIN
> 213 345 567
> 847 837 473
> \.
>
Thanks. Was this query entered in psql shell?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
If you happen to be using JDBC you can also get copy to work:
http://kato.iki.fi/sw/db/postgresql/jdbc/copy/
On Wed, Oct 1, 2008 at 9:24 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 1, 2008 at 6:44 AM, Sergey A. <[EMAIL PROTECTED]> wrote:
> > Hello.
> >
> > My application generate
On Wed, Oct 1, 2008 at 6:44 AM, Sergey A. <[EMAIL PROTECTED]> wrote:
> Hello.
>
> My application generates a large amount of inserts (~ 2000 per second)
> using one connection to PostgreSQL. All queries are buffered in memory
> and then the whole buffers are send to DB. But when I use two
> connect
Mike Christensen <[EMAIL PROTECTED]> writes:
> As you can see the index is not being used and it's doing a seq scan
> on the table directly. I would think if Postgres is indeed keeping a
> btree index on the column, meaning the values would be stored in
> numerical order, the index would be
In response to "Sergey A." <[EMAIL PROTECTED]>:
>
> > Multiple cores are not the solution to your problem here, but COPY
> > almost certainly is :)
> But as I can see this approach doesn't work over network: I need to
> create file with data locally, and then ask PostgreSQL to read it.
There is a
On Wed, Oct 1, 2008 at 6:58 AM, Sergey A. <[EMAIL PROTECTED]> wrote:
> Hello.
>
>> You can use it for whatever you're generating.
> I've tested this technique, and I'm wondering! 12 inserts per
> ~600ms! Thanks for your help.
>
>> Multiple cores are not the solution to your problem here, but CO
On Wed, Oct 1, 2008 at 1:57 PM, Mike Christensen <[EMAIL PROTECTED]> wrote:
> Hi guys, I'm very new to PostgreSQL so please excuse me if this is an easy
> question..
>
> I have a table called Recipes which has a column called CookTime. I have
> an index on the CookTime column as such:
>
> CREATE
Hello.
> You can use it for whatever you're generating.
I've tested this technique, and I'm wondering! 12 inserts per
~600ms! Thanks for your help.
> Multiple cores are not the solution to your problem here, but COPY
> almost certainly is :)
But as I can see this approach doesn't work over ne
On Wed, Oct 01, 2008 at 05:13:59AM -0700, Sergey A. wrote:
> Hello.
>
> > Are you using COPY? If not, start there :)
>
> I'm new to PostgreSQL. No, I'm not using COPY =) Are you about
> http://www.postgresql.org/docs/8.3/interactive/sql-copy.html (COPY --
> copy data between a file and a table)?
On Wed, Oct 01, 2008 at 03:44:40AM -0700, Sergey A. wrote:
> Hello.
>
> My application generates a large amount of inserts (~ 2000 per
> second) using one connection to PostgreSQL. All queries are
> buffered in memory and then the whole buffers are send to DB.
Are you using COPY? If not, start
Sergey A. wrote:
> I know that I can use a connection pooler to involve early created
> connections. Can poolers balance queries coming from my connection
> among a few physical connections to DB?
The pg_loader project might be of use to you.
http://pgfoundry.org/projects/pgloader/
--
Richa
Hello.
> I don't think so. Postgres spawns a single process for each connection,
> so each connection is going to be confined to a single core.
Thanks for your answer.
I know that I can use a connection pooler to involve early created
connections. Can poolers balance queries coming from my conne
On 01/10/2008 11:44, Sergey A. wrote:
> Using several connections in my application is somewhat tricky, so I
> want to move this problem to PostgreSQL's side. Is there any method
> for PostgreSQL to process huge inserts coming from one connection on
> different cores?
I don't think so. Postgres s
Hello.
My application generates a large amount of inserts (~ 2000 per second)
using one connection to PostgreSQL. All queries are buffered in memory
and then the whole buffers are send to DB. But when I use two
connections to PostgreSQL instead of one on dual core CPU (i.e. I use
two processes of
Hi.
It is strange?_?
pg_config.h and pg_config_os.h must be copied as below.
C:\MinGW\home\HIROSHI\postgresql-8.3.3\src\interfaces\libpq>nmake -f win32.mak
Microsoft (R) Program Maintenance Utility Version 8.00.50727.42
Copyright (C) Microsoft Corporation. All rights reserved.
Building the Wi
Hi guys, I'm very new to PostgreSQL so please excuse me if this is an
easy question..
I have a table called Recipes which has a column called CookTime. I
have an index on the CookTime column as such:
CREATE INDEX idx_recipes_cooktime
ON recipes
USING btree
(cooktime);
If I run the f
Darragh Gammell wrote:
> I am currently upgrading from 8.1 to 8.3 and am getting errors when
> restoring the dump from 8.1 into 8.3. Like below:
> I have read this is due to the tsearch2 functions being moved into the core
> section of postgres and I'll need to do some editing after the dump to
>
Okay, that's a misunderstanding.
I don't want to build it from the sources. I want to take the official
pre-built "postgres without installer" package and put it on a Windows
machine to make it work. That doesn't work (while it should IMHO)
because of the dependencies. So I just want to add som
Jörn Heid wrote:
Thanks Ashesh for your answer.
I will try to do so although I first have to install VC (or can I just
use the directories from WinSxS?). Is there another possibility
without setting an environment variable? Think of the simplest
distribution of just copying files (e.g. to a U
52 matches
Mail list logo
