Hello,
I try to restore a dump file on a new Database. But unfortunatly i get this
error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 532; 2612 16386 PROCEDURAL
LANGUAGE plpgsql postgres
pg_restore: [archiver (db)] could not execute
> I found comment in src/backend/optimizer/path/pathkeys.c:
> * EXCEPTION: in a FULL or RIGHT join, we cannot treat the result as
> * having the outer path's path keys, because null lefthand rows may be
> * inserted at random points. It must be treated as unsorted.
>
> How can I get rid of this so
Maciej Sieczka wrote:
I need to modify this default PostgreSQL's behaviour, so that the ACL on
a new table in this schema is set to SELECT, INSERT, UPDATE, DELETE,
REFERENCES for "editors", and SELECT for "viewers", without having to
manually GRANT rights each time a new table is created. I can'
On Mon, Feb 25, 2008 at 06:40:43PM +0100, Andreas Lau wrote:
> Hello,
>
> I try to restore a dump file on a new Database. But unfortunatly i get this
> error:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 532; 2612 16386 PROCEDUR
On Tue, Feb 26, 2008 at 10:26:25AM +0100, Martijn van Oosterhout wrote:
> On Tue, Feb 26, 2008 at 10:23:05AM +0100, Magnus Hagander wrote:
> > Any chance you are running pg_dump/pg_restore version 8.3? The syntax
> > appears to be what 8.3 uses, not 8.3..
> >
> > You can use (and should use) an 8.
On Tue, Feb 26, 2008 at 10:23:05AM +0100, Magnus Hagander wrote:
> Any chance you are running pg_dump/pg_restore version 8.3? The syntax
> appears to be what 8.3 uses, not 8.3..
>
> You can use (and should use) an 8.3 pg_dump to dump your 8.2 database when
> upgrading to 8.3, but you often can't r
ERROR: canceling autovacuum task
CONTEXT: automatic vacuum of table "metadb.test.transactions"
Are these happening regularly? They indicate that something is
happening on the table that collides with what autovacuum needs to do,
and autovacuum defers its task. For this to happen you need t
Thanks for your hinds.
It's true i used pg_dump and pg_restore version 8.3 to dump and restore 8.2
databases. I wouldn't have thought that there could be problems. But it seems
so. I will give it a try an report the result.
Thanks Andreas
-Ursprüngliche Nachricht-
Von: Magnus Hagander [
"Alexey A. Nalbat" <[EMAIL PROTECTED]> writes:
> Yes. But may be the FULL MERGE JOIN could be improved, because it
> is ordered, it actually has "outer path's path key": "coalesce(id1,id2)".
Hm, there's more going on here than meets the eye. If you changed the query
slightly Postgres would actua
On Tue, Feb 26, 2008 at 3:11 PM, Stuart Brooks <[EMAIL PROTECTED]> wrote:
>
> >> ERROR: canceling autovacuum task
> >> CONTEXT: automatic vacuum of table "metadb.test.transactions"
> >
> > Are these happening regularly? They indicate that something is
> > happening on the table that collide
>> ERROR: canceling autovacuum task
>> CONTEXT: automatic vacuum of table "metadb.test.transactions"
>
> Are these happening regularly? They indicate that something is
> happening on the table that collides with what autovacuum needs to do,
> and autovacuum defers its task. For this to
I'm working on a CMS that, in addition to the database-stored version
of articles for easy searching, sorting, etc, also stores a HTML file
version so pages can be fetched with the minimum of overhead (browsing
articles has no more overhead than accessing any other HTML file on
the server).
As I'v
Gordon wrote:
I need to find a way of not running queries that I don't need to,
either in the PHP script, or in the Postgres database. What I need is
for a result set to be cached somewhere, either by Postgres or PHP, so
when it sees the same query again in a given session it just returns
the pr
"Stuart Brooks" <[EMAIL PROTECTED]> writes:
> It'll take a few minutes but I'll try and get the information to you. A
> summary
> is:
>
> Process 1:
> - writing 50 rows/second, 1 row/transaction.
> - every so often delete 100 rows
>
> Process 2:
> - running ANALYZE VERBOSE and pg_total_relation_s
Stuart Brooks wrote:
> I am not using an ALTER table command but I am doing periodic ANALYZEs
> to evaluate the table size. Could this be causing the problem? I notice
> that stopping the ANALYZE calls appears to eliminate the canceled
> autovacuum.
Why were you running ANALYZE on the first
My problem seems to be solved. Actually it was because of the differences
between the version of pg_dump/pg_restore (8.3) and of my postgres DB (8.2.6).
As i used the appropriate versions for pg_dump/pg_restore the restauration runs
through without any errors.
Thanks for that Andreas
Actually
It'll take a few minutes but I'll try and get the information to you. A summary
is:
Process 1:
- writing 50 rows/second, 1 row/transaction.
- every so often delete 100 rows
Process 2:
- running ANALYZE VERBOSE and pg_total_relation_size every second
You'll probably have to vacuum pg_sta
Il giorno 24/feb/08, alle ore 04:53, justin tocci ha scritto:
In its most basic form a great tool would just start as a pl/pgsql
or pl/perl function that could be used to call a table and have it
output a batch of records to an editable html form or a colored pdf
for nice reports. There wou
--- justin tocci <[EMAIL PROTECTED]> wrote:
> interface? I've thought about it enough to want to try it. I don't
> really know how APEX / HTML DB work so I'm open to suggestions. I
> can
> either put the controller in a perl module and send intelligent
> requests for formatted pages to postg
What concerns me is that once the size has grown, even a VACUUM FULL
doesn't recover the space. Regular external VACUUMs keep the table at
around 10MB but if I use autovacuum and it grows to 40MB, a VACUUM FULL
will only get it down to 35MB. Is it possible that a canceled autovacuum
could r
I have the following problem getting to connect a remote database (MS
SQL Server in my case) to PostgreSQL.
I'm using SQL Server 2005 Express Edition. I tried it with the following:
SELECT dbi_link.make_accessor_functions(
'dbi:ODBC:DRIVER=SQL Native
Client;Server=192.168.10.175;Database=Test;
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Alexey A. Nalbat" <[EMAIL PROTECTED]> writes:
>> Yes. But may be the FULL MERGE JOIN could be improved, because it
>> is ordered, it actually has "outer path's path key": "coalesce(id1,id2)".
No, it does not have the outer path's path key. The outer pa
On Tue, 2008-02-26 at 10:34 -0500, Tom Lane wrote:
> > and add COALESCE(id2,id1) to it as well I think.
>
> No, because those two expressions are not equivalent. (Hmm ... squint
> ... but full merge join is pretty much symmetric, so it's not clear
> why it should matter which side is left or righ
Richard Huxton pisze:
Maciej Sieczka wrote:
I need to modify this default PostgreSQL's behaviour, so that the ACL on
a new table in this schema is set to SELECT, INSERT, UPDATE, DELETE,
REFERENCES for "editors", and SELECT for "viewers", without having to
manually GRANT rights each time a new t
Stuart Brooks <[EMAIL PROTECTED]> writes:
> Process 2:
> - running ANALYZE VERBOSE and pg_total_relation_size every second
> The result is that autovacuum appears to be canceled.
Yes, that will pretty much guarantee that an autovacuum is never able to
complete...
> What concerns me is that once
Simon Riggs <[EMAIL PROTECTED]> writes:
> On Tue, 2008-02-26 at 10:34 -0500, Tom Lane wrote:
> and add COALESCE(id2,id1) to it as well I think.
>> No, because those two expressions are not equivalent. (Hmm ... squint
>> ... but full merge join is pretty much symmetric, so it's not clear
>> why it
Stuart Brooks wrote:
It'll take a few minutes but I'll try and get the information to you. A
summary is:
Process 1:
- writing 50 rows/second, 1 row/transaction.
- every so often delete 100 rows
Process 2:
- running ANALYZE VERBOSE and pg_total_relation_size every second
The result is that aut
Hi,
How can I make custom conversion? The postgres-documentation can't help
me :(
I'm find this only, but without any examples:
http://www.postgresql.org/docs/8.3/interactive/sql-createconversion.html
CREATE [ DEFAULT ] CONVERSION name
FOR source_encoding TO dest_encoding FROM funcname
On Feb 26, 11:11 am, Gordon <[EMAIL PROTECTED]> wrote:
> I'm working on a CMS that, in addition to the database-stored version
> of articles for easy searching, sorting, etc, also stores a HTML file
> version so pages can be fetched with the minimum of overhead (browsing
> articles has no more over
Gordon wrote:
I'm working on a CMS that, in addition to the database-stored version
of articles for easy searching, sorting, etc, also stores a HTML file
version so pages can be fetched with the minimum of overhead (browsing
articles has no more overhead than accessing any other HTML file on
the
Maciej Sieczka wrote:
Richard Huxton pisze:
Afraid not. You can't add a trigger to a system table.
Too bad, but thanks much for clarifying this.
The only real solution is to have your own function do both - create
the table and then grant relevant permissions. Only allow client
applications
I wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> as a path key, though we would have to create an equivalence class
>> and add COALESCE(id2,id1) to it as well I think.
> No, because those two expressions are not equivalent. (Hmm ... squint
> ... but full merge join is pretty much symmetric
"Norman Peelman" <[EMAIL PROTECTED]> writes:
>> My options are, as far as I can tell,
>>
>> 1) replace the Database PDO extending class with something else that
>> provides query results caching in PHP, or
>> 2) get Postgres itself to cache the results of queries to avoid
>> running them repeatedl
TJ O'Donnell wrote:
I've been running PostgreSQL on a virtual server for several years
now. I'm using VMWare with a Windows host and Linux guest. I've
configured it to let Linux use a raw partition as a disk. Before I
used a separate partition, the virtual disk had been a Windows
file. Using
"Tom Lane" <[EMAIL PROTECTED]> writes:
> I wrote:
>> Gregory Stark <[EMAIL PROTECTED]> writes:
>>> as a path key, though we would have to create an equivalence class
>>> and add COALESCE(id2,id1) to it as well I think.
>
>> No, because those two expressions are not equivalent. (Hmm ... squint
>>
Yuri Gordienko <[EMAIL PROTECTED]> writes:
> How can I make custom conversion? The postgres-documentation can't help
> me :(
I'd suggest you start by copying-and-pasting one of the existing
conversion functions. Look under src/backend/utils/mb/conversion_procs/
in the source distribution.
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>> It might still be interesting sometime to have a more bespoke
>> representation for a merged variable, but I guess we don't need
>> it just for this.
> It might have an advantage if you're doing a three-way outer
Richard Huxton pisze:
Maciej Sieczka wrote:
Richard Huxton pisze:
Afraid not. You can't add a trigger to a system table.
Too bad, but thanks much for clarifying this.
The only real solution is to have your own function do both - create
the table and then grant relevant permissions. Only all
Maciej Sieczka wrote:
I'd like to prevent concurrent editing of a table. For example PostGIS
tables, which are going to be stored in the database too: once a user
starts editing the table in QGIS [1], it should be locked (for writing
at least), until he turns the edit mode off and commits cha
Hello everybody. I recently converted my db from ASCII encoding to UTF8
(we have a lot of spanish-speaking members, and need the extra character
support). Everything was working great, but I noticed this error, while
trying to COPY one of our tables from a csv.
ERROR: invalid byte sequence for
Is there a simple way to copy a table from one database to another without
generating an intermediate dump file?
TIA!
Kynn
Kynn Jones wrote:
Is there a simple way to copy a table from one database to another
without generating an intermediate dump file?
TIA!
Kynn
You're looking for ETL.
http://en.wikipedia.org/wiki/Extract%2C_transform%2C_load
--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
S
On Tue, Feb 26, 2008 at 9:19 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
>
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
Using UNIX pipes :-)
$ pg_dump ... | psql ...
:-)
Regards,
Dawid
---(e
Tom Hart wrote:
Hello everybody. I recently converted my db from ASCII encoding to UTF8
(we have a lot of spanish-speaking members, and need the extra character
support). Everything was working great, but I noticed this error, while
trying to COPY one of our tables from a csv.
ERROR: invalid
Kynn Jones wrote:
Is there a simple way to copy a table from one database to another without
generating an intermediate dump file?
Something along the lines of:
pg_dump ... -d db1 --table=mytable | psql -d db2
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
On Tuesday 26 February 2008, Kynn Jones wrote:
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
> TIA!
>
> Kynn
pg_dump -t [table] [database] | psql -U [remoteuser] -h [remotehost]
[remotedatabase]
comes to mind...
You can an
On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
>
> Is there a simple way to copy a table from one database to another
> without generating an intermediate dump file?
>
pg_dump -t | psql -d
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
On Tue, Feb 26, 2008 at 2:36 PM, Brad Nicholson
<[EMAIL PROTECTED]> wrote:
> On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
> >
> > Is there a simple way to copy a table from one database to another
> > without generating an intermediate dump file?
> >
>
> pg_dump -t | psql -d
Starti
Tom Hart wrote:
> Hello everybody. I recently converted my db from ASCII encoding to UTF8
> (we have a lot of spanish-speaking members, and need the extra character
> support). Everything was working great, but I noticed this error, while
> trying to COPY one of our tables from a csv.
>
> ERR
Richard Huxton wrote:
Tom Hart wrote:
Hello everybody. I recently converted my db from ASCII encoding to
UTF8 (we have a lot of spanish-speaking members, and need the extra
character support). Everything was working great, but I noticed this
error, while trying to COPY one of our tables from a
Hi,
I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).
As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.
AFAIK stopping the server, zipping data dir, and restartin
> AFAIK stopping the server, zipping data dir, and restarting
> the server creates a zip file which is not easily portable to
> other computers due to some ntfs file system permission problems.
>
IIRC you have to re-assign owner and change permissions after you copy your
data dir to the new serv
[EMAIL PROTECTED] wrote:
Hi,
I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).
As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.
AFAIK stopping the server, zipp
On Tue, Feb 26, 2008 at 3:51 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> As discussed earlier I can't use dump/dumpall since my data needs
> persistent tableoids which, however, are not the same after a restore.
What about the workarounds / refactoring tips proposed in previous discussion
Richard Huxton pisze:
Maciej Sieczka wrote:
In PG experts
opinion, could/should a PostGIS editing software lock table for
writing to prevent concurent editing?
The application should either:
1. Take an advisory lock (see the functions/admin functions chapter) so
that it can use another ta
On 2008-02-26 13:04, Tom Hart wrote:
I already have a php script that does some data scrubbing before the
copy. I added this line to the script and things seem to be working
better now
$line = iconv("ISO-8859-1", "UTF-8", $line);
Thanks for the help guys :-)
Read up on the difference bet
I just downloaded postgres 8.3 for windows and noticed that citext is
not an option for columns.
The web site has the source code but no binaries for windows.
I downloaded the enterprisedb and noticed that it has the citext.dll
in the lib directory so I copied the dll over to the postgres lib
dir
I'm not sure if you're saying I should ignore these errors...
I'm using dumps from DB airaburst.
>postgres=# \l
List of databases
Name| Owner | Encoding
+--+---
airburst | root | SQL_ASCII
lt_dev1| postgres | UTF8
lt_dev2| postgre
Ralph Smith <[EMAIL PROTECTED]> writes:
> I'm not sure if you're saying I should ignore these errors...
No, not at all.
> I'm using dumps from DB airaburst.
Doesn't look like that --- you have
> Name| Owner | Encoding
> +--+---
> airburst | root |
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Gevik
>Babakhani
>Sent: Tuesday, 26 February 2008 22:30
>To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
>Subject: Re: [GENERAL] win32: how to backup (dump does not work)
>
>> AFAIK stopping the serve
These create table commands succeed, even tho the foreign key refers to a
'different' type (int2 product_id column refers to an int8 column):
CREATE TABLE products (
id int8 primary key,
name text not null
);
CREATE TABLE orders (
id int8 PRIMARY KEY,
product_id int2 not null REF
On Tue, 26 Feb 2008, craigp wrote:
> These create table commands succeed, even tho the foreign key refers to
> a 'different' type (int2 product_id column refers to an int8 column):
The requirements in recent SQL specs appears to be that the column types
are comparable, not the same.
SQL2003 11.8
Hello !
I have a week number (ISO 8601) and a year, based on theses values, I
would like to get the first and the last dates of that week.
How I can do that ?
The only solution is doing a big generate_series to build a subset that
contains the week of all the dates between the 01/01 || year
On Tuesday 26 February 2008 5:32 pm, Bruno Baguette wrote:
> Hello !
>
> I have a week number (ISO 8601) and a year, based on theses values, I
> would like to get the first and the last dates of that week.
>
> How I can do that ?
>
> The only solution is doing a big generate_series to build a subse
Bruno Baguette wrote:
Hello !
I have a week number (ISO 8601) and a year, based on theses values, I
would like to get the first and the last dates of that week.
How I can do that ?
The only solution is doing a big generate_series to build a subset that
contains the week of all the dates bet
Where can I get uuid-ossp for windows? Also where can I get citext for windows.
These two are missing from the windows installer.
Thanks.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org
On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun <[EMAIL PROTECTED]> wrote:
> Where can I get uuid-ossp for windows? Also where can I get citext for
> windows.
>
> These two are missing from the windows installer.
Search the archives. There was a conversation about this in the last
week or two. Bas
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Tue, 26 Feb 2008, craigp wrote:
>> These create table commands succeed, even tho the foreign key refers to
>> a 'different' type (int2 product_id column refers to an int8 column):
> The requirements in recent SQL specs appears to be that the column ty
Hi.
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun <[EMAIL PROTECTED]> wrote:
Where can I get uuid-ossp for windows? Also where can I get citext for windows.
These two are missing from the windows installer.
Search the
Adrian Klaver <[EMAIL PROTECTED]> writes:
> On Tuesday 26 February 2008 5:32 pm, Bruno Baguette wrote:
>> I have a week number (ISO 8601) and a year, based on theses values, I
>> would like to get the first and the last dates of that week.
> This will get you to the Monday of the week .
> select
Anyone have any ideas, or is there another list for install questions?
Dee <[EMAIL PROTECTED]> wrote: I am trying to install version 8.3 on windows
2000. I created a Local account named "postgres" and granted it "Log on as a
service" and "Log on locally" rights as described here
http://
On Tuesday 26 February 2008 8:39 pm, Tom Lane wrote:
> Adrian Klaver <[EMAIL PROTECTED]> writes:
> > On Tuesday 26 February 2008 5:32 pm, Bruno Baguette wrote:
> >> I have a week number (ISO 8601) and a year, based on theses values, I
> >> would like to get the first and the last dates of that week
Adrian Klaver <[EMAIL PROTECTED]> writes:
> On Tuesday 26 February 2008 8:39 pm, Tom Lane wrote:
>> date_trunc('week', ...) would probably be a more convenient way of doing
>> that.
> I am not sure I follow. The OP has a ISO week number and a year and wants
> dates. I thought date_trunc('field',s
Richard, did you ever get this issue sorted?
I have encountered a similar situation that came about when I upgraded
to postgres 8.3. Now it won't start stating that:
The server must be started under the locale : which does not exist any more
(it looks like the locale is set to {blank} ???)
N
Process 2:
- running ANALYZE VERBOSE and pg_total_relation_size every second
The result is that autovacuum appears to be canceled.
Yes, that will pretty much guarantee that an autovacuum is never able to
complete...
That's what I figured. Since I won't be running ANALYZE u
75 matches
Mail list logo