Scott Clement wrote:
I am getting an error message when initdb run
The program
/usr/bin/postgresql
need by initdb does not belong to PostgreSQL 7.4.7 or
there may be a configuration problem.
I'm going to guess a version issue.
You have initdb for a different version of postgres than the
/
I'm look for documentation about server optimization.
the only thing I find is QUERY optimization.
there are a lot of parameter in postgresql.conf
no site explain which value is better
---(end of broadcast)---
TIP 5: don't forget to increase your fr
On Sat, Aug 05, 2006 at 08:27:25PM -0300, Jorge Godoy wrote:
> Paul M Foster <[EMAIL PROTECTED]> writes:
> > Here's an example: The user wants to enter a bill (accounts payable)
> > into the system. He first has to pick a vendor. Normally, this would
> > entail a PHP page that generates a PostgreS
YannicK wrote:
I'm look for documentation about server optimization.
the only thing I find is QUERY optimization.
there are a lot of parameter in postgresql.conf
no site explain which value is better
This is a good place to start.
http://www.powerpostgresql.com/PerfList
--
Richard Huxton
A
Hello,within my log there is the following snippet:2006-08-07 13:20:27 LOG: autovacuum: processing database "template1"2006-08-07 13:20:47 ERROR: could not open relation with OID 3114382006-08-07 13:21:52 LOG: autovacuum: processing database "postgres"
now there are a number of possibilites, why
"Harald Armin Massa" <[EMAIL PROTECTED]> writes:
> within my log there is the following snippet:
> 2006-08-07 13:20:27 LOG: autovacuum: processing database "template1"
> 2006-08-07 13:20:47 ERROR: could not open relation with OID 311438
> 2006-08-07 13:21:52 LOG: autovacuum: processing database
Hi,
It looks as if psql has internal variables I am how
ever not able to get it to work in the way I want.
I need to store the current date and then delete all
elements from 3 tables based on the same date.
I tried to set the variable curtime:
set curtime now()
but I could not use it in a dele
Sorry, it’s a problem
resulting from my company which forbids FTP downloading.
From: kevin.huang
[mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 2:17
PM
To: 'pgsql-general@postgresql.org'
Subject: does pgsql downloading
mirror sites work?
Hi,
I tried to downlo
Hi,
I tried to download pgsql database from the mirror websites,
but it seems that all of them can not be connected?
What’s the problem?
Kevin
> 2006-08-07 13:20:27 LOG: autovacuum: processing database "template1"
> 2006-08-07 13:20:47 ERROR: could not open relation with OID 311438> 2006-08-07 13:21:52 LOG: autovacuum: processing database "postgres"The easiest explanation is that someone dropped a table just as
autovacuum was trying to
"Harald Armin Massa" <[EMAIL PROTECTED]> writes:
>> The easiest explanation is that someone dropped a table just as
>> autovacuum was trying to open it.
> I am not quite sure that "autovacuum" was trying to open, as some user
> reported the same error on his system ( and he is definitely not mr.
>
On Mon, 07 Aug 2006 11:14:53 +0100
Richard Huxton wrote:
> YannicK wrote:
> > I'm look for documentation about server optimization.
> > the only thing I find is QUERY optimization.
> > there are a lot of parameter in postgresql.conf
> > no site explain which value is better
>
> This is a good pl
> Oh, I assumed you had reason to think that the error message came from> autovacuum. It could easily have been the same situation except two> unrelated processes.Surely my mistake in error reporting. Just cut out the "surrounding lines" from the log; like in contextual diff :(
> What indeed happe
Hello everyone,
First of all, thank you for integrating XPath in Postgresql.
But, as you will see, this is a desperate cry for help:
1. the actual context:
Postgresql 8.1.4, Fedora Core 5
DATABASE
=
CREATE TABLE xmldocuments
(
id int8 NOT NULL,
rawdata text,
title varchar(255),
[snip]
>
[snip]
> xpath_bool(rawdata,'/mydocument/body/chapter/contents/paragraph[objid="2_1"]');
^
To me it looks like attribute name mismatch, n
Thanks for replying.
It was a typo ...
Also id fom example should be objid ...
Anyway, without the typo, the result set is empty.
There is also a weird thing:
SELECT
xpath_nodeset(rawdata, '/mydocument/body/chapter/contents/paragraph')
FROM xmldocuments
will output
xpath_nodeset
Marian POPESCU wrote:
> There is also a weird thing:
>
>
> SELECT
> xpath_nodeset(rawdata,
> '/mydocument/body/chapter/contents/paragraph') FROM xmldocuments
>
> will output
>
> xpath_nodeset
>
> (empty line)
> (empty line)
> (empty line)
> (empty line)
>
> 4 record(s
Marian,
On Mon, 2006-08-07 at 17:47, Marian POPESCU wrote:
> SELECT
> xpath_nodeset(rawdata, '/mydocument/body/chapter/contents/paragraph')
> FROM xmldocuments
>
> will output
>
> xpath_nodeset
>
> (empty line)
> (empty line)
> (emp
It looks that I shoot myself in the foot :(
CREATE TABLE xmltable
(
id int8 NOT NULL,
xml_data text,
CONSTRAINT pk_xmltable PRIMARY KEY (id)
)
WITHOUT OIDS;
The id field contains values from 1 to 3.
The field xml_data contains something like this:
My document
You are right; I had a typo : contents is content
Thanks for replying ...
Guy Rouillier wrote:
> Marian POPESCU wrote:
>> There is also a weird thing:
>>
>>
>> SELECT
>> xpath_nodeset(rawdata,
>> '/mydocument/body/chapter/contents/paragraph') FROM xmldocuments
>>
>> will output
>>
>> xpath
Marian,
> 1.
> SELECT
> xpath_nodeset(xml_data, '/mydocument/body/chapter/contents/[EMAIL
> PROTECTED]
> = "02"]|/mydocument/body/[EMAIL PROTECTED]"87"]')
> FROM xmltable
> WHERE id = 3
You could maybe use the xpath: '//[EMAIL PROTECTED] = "02"]' if you want
all paragraphs at all docume
On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
> > The evasive answer is that you probably don't run regular full pg_dump
> > on such databases.
>
> Hmmm.
>
You might want to use PITR for incremental backup or maintain a standby
system using Slony-I ( www.slony.info ).
> >> Are there
Thank you!
Since you brought up the subject, will this
//[EMAIL PROTECTED] = "02"]
be slower than
/mydocument/body/chapter/contents/[EMAIL PROTECTED]
>> = "02"]
when handling a big document?
I mean from the query time point of view ...
Csaba Nagy wrote:
> Marian,
>
>> 1.
>> SELECT
>>
We create psql scripts that can be used at various times by various
users. I have been unable to find how to absolutely set various options
(timing, expanded, etc.) rather than toggle them.
The --no-psqlrc option provides a partial workaround - as long as the
user remembers to include it and a
Last week I upgraded to postgresql 8.1.4
(YEAH!) In my database I have a view which concatenates three varchar
fields to a new field. With postgresql 7.2.3 the field resulting from the
concatenation was a varchar, with postgresql 8.1.4 the new field is a text
field. This is affecting all kinds of
Really, I dont see the 3 varchar fields concatenated to a new field.
But do this
(varchar1||varchar2||varchar3||newfield)::varchar
Best regards
[EMAIL PROTECTED] wrote:
Last week I upgraded to postgresql 8.1.4 (YEAH!) In my database I
have a view which concatenates three varchar fields
Well, you cast all those fields to be concatenated to text. Why should the db
make a varchar out of that? I seriously doubt that 7.x made a varchar of that
- but then, 7.2 is very very old.
So either cast your fields to varchar (i.e. c.refullname::varchar ||
d.enname::varchar) or cast the result
>Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote
on 08/07/2006 11:36:28 AM:
> Really, I dont see the 3 varchar fields concatenated to a new field.
>
> But do this
>
> (varchar1||varchar2||varchar3||newfield)::varchar
>
> Best regards
>
This is the concatenate statement
> > SELECT b.ltname, (c
SELECT b.ltname, ((c.refullname::text || d.enname::text) ||
f.evname::text)::varchar AS evlinkname1,
[EMAIL PROTECTED] wrote:
>Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote on 08/07/2006 11:36:28 AM:
> Really, I dont see the 3 varchar fields concatenated to a new field.
>
> But do this
>
> (v
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis wrote:
> On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
>
>>> The evasive answer is that you probably don't run regular full pg_dump
>>> on such databases.
>> Hmmm.
>>
>
> You might want to use PITR for incremental backup or mainta
Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote
on 08/07/2006 11:41:52 AM:
> SELECT b.ltname, ((c.refullname::text || d.enname::text) ||
> f.evname::text)::varchar AS evlinkname1,
>
This worked, thank you.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
Margaret Gill
On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Jeff Davis wrote:
> > On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
> > pg_dump just produces output. You could pretty easily stripe that output
> > across multiple devices just by using
"Uwe C. Schroeder" <[EMAIL PROTECTED]>
wrote on 08/07/2006 11:30:28 AM:
> Well, you cast all those fields to be concatenated to text. Why should
the db
> make a varchar out of that? I seriously doubt that 7.x made a varchar
of that
> - but then, 7.2 is very very old.
> So either cast your field
>"Uwe C. Schroeder" <[EMAIL PROTECTED]>
wrote on 08/07/2006 11:30:28 AM:
> Well, you cast all those fields to be concatenated to text. Why should
the db
> make a varchar out of that? I seriously doubt that 7.x made a varchar
of that
> - but then, 7.2 is very very old.
> So either cast your field
On Mon, 2006-08-07 at 14:11, [EMAIL PROTECTED] wrote:
> >"Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote on 08/07/2006 11:30:28 AM:
> > Well, you cast all those fields to be concatenated to text. Why
> should the db
> > make a varchar out of that? I seriously doubt that 7.x made a
> varchar of that
>Scott Marlowe <[EMAIL PROTECTED]>
wrote on 08/07/2006 12:18:17 PM:
>
> Just FYI, text and varchar are, internally, pretty
much the same types.
> varchar has an optional precision setting as in varchar(200) while
text
> does not allow one.
>
> All the text ops are written for text types, so varc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
> On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Jeff Davis wrote:
>>> On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
>
>>> pg_dump just produces output. You could
> Say we have a 7GB database. Is there a way to way to use 2 tape
> drives... Argh, I guess not, since the Unix pipe mentality presumes
> that the mode of operation will be:
> $ pg_dump /some/database | tar cvfz /dev/st0/db.tgz
>
> What would be darned useful (but only, I think, with heavy us
On Mon, 2006-08-07 at 14:51, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Scott Marlowe wrote:
> > On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
> >> -BEGIN PGP SIGNED MESSAGE-
> >> Hash: SHA1
> >>
> >> Jeff Davis wrote:
> >>> On Mon, 2006-07-31 at 09:53 -0500
Hi Paul :
You can use deferred load do this.
I am using tu active /deactive user without open a window and going to other
page and return.
No ajax in this code.
--
// This is in the user form...
--
function AtivaDesativar( sD
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard Broersma Jr wrote:
>> Say we have a 7GB database. Is there a way to way to use 2 tape
>> drives... Argh, I guess not, since the Unix pipe mentality presumes
>> that the mode of operation will be:
>> $ pg_dump /some/database | tar cvfz /dev/
On Fri, 2006-08-04 at 18:01, Gregory Stark wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> > > I sort of expected the release of the savepoint to be tantamount to a
> > > commit of the subtransaction, but it doesn't appear to have been.
> >
Thanks sir.
Is it safe to use the Postgres 8.1.4 pg_dump utility to dump data from a postgres 7.1.2 database?
Thanks again :)
Jonathan Valllar
On 8/5/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jonathan Vallar" <[EMAIL PROTECTED]> writes:
> After dumping the database. I tried to load it on Pos
Ron Johnson <[EMAIL PROTECTED]> writes:
> Say we have a 7GB database. Is there a way to way to use 2 tape
> drives... Argh, I guess not, since the Unix pipe mentality presumes
> that the mode of operation will be:
> $ pg_dump /some/database | tar cvfz /dev/st0/db.tgz
If you use "z" you're com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
> On Mon, 2006-08-07 at 14:51, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Scott Marlowe wrote:
>>> On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash:
On Mon, 2006-08-07 at 15:18, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Scott Marlowe wrote:
> >
> > Oh, I see where you were headed.
> >
> > I've found a bit here and there googling about for multiplex and tar,
> > and found an IO:Multiplex module for perl.
> >
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
> On Mon, 2006-08-07 at 15:18, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Scott Marlowe wrote:
>>> Oh, I see where you were headed.
>>>
>>> I've found a bit here and there googling about for multip
On Mon, 2006-08-07 at 14:51 -0500, Ron Johnson wrote:
> What would be darned useful (but only, I think, with heavy usage of
> tablespaces) is:
> $ pg_tapedump /some/database /dev/st0,/dev/st1,/dev/st2,/dev/st3
I must be missing something. What is stopping you from doing something
along the line
Ron Johnson wrote:
> This is where a multi-threaded pg_tapedump would be more effective,
> since it would be able to, for example, have 4 threads reading
> (different parts of) the database and writing to 4 separate tape drives.
It will be difficult to have a consistent dump though. You can't do
On Mon, 2006-08-07 at 16:09, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Scott Marlowe wrote:
> > On Mon, 2006-08-07 at 15:18, Ron Johnson wrote:
> >> -BEGIN PGP SIGNED MESSAGE-
> >> Hash: SHA1
> >>
> >> Scott Marlowe wrote:
> >>> Oh, I see where you were heade
Jonathan Vallar wrote:
> Thanks sir.
>
> Is it safe to use the Postgres 8.1.4 pg_dump utility to dump data from a
> postgres 7.1.2 database?
Yes.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis wrote:
> On Mon, 2006-08-07 at 14:51 -0500, Ron Johnson wrote:
>
>> What would be darned useful (but only, I think, with heavy usage of
>> tablespaces) is:
>> $ pg_tapedump /some/database /dev/st0,/dev/st1,/dev/st2,/dev/st3
>
> I must be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alvaro Herrera wrote:
> Ron Johnson wrote:
>
>> This is where a multi-threaded pg_tapedump would be more effective,
>> since it would be able to, for example, have 4 threads reading
>> (different parts of) the database and writing to 4 separate tape d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
> On Mon, 2006-08-07 at 16:09, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Scott Marlowe wrote:
>>> On Mon, 2006-08-07 at 15:18, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash:
Thor Tall wrote:
> If I just delete from table_a and then table_b and the
> table_c I may risk deleting rows in table_b and
> table_c which correspond to rows in table_a. (due to
> the different times returned by now();
now() returns a constant value in a transaction.
--
Peter Eisentraut
http://
On Mon, 2006-08-07 at 16:51 -0500, Ron Johnson wrote:
> Python queues and threads would make that very simple. Master
> thread reads from pg_dump pipe, passing X bytes to a queue, and each
> thread performs this loop:
> - read from queue
> - synchronously write to /dev/stN
Right, you can use
Steve Crawford wrote:
> So...have I overlooked an interactive psql option that will let me
> reset all options to "factory-defaults" or a method of specifying an
> absolute setting to the various options?
Probably not.
> If not, do psql users out there feel this is worth a feature request?
I thi
On Mon, 2006-08-07 at 16:53 -0500, Ron Johnson wrote:
> > It will be difficult to have a consistent dump though. You can't do
> > that with separate transactions. (And you can't have multiple
> > simultaneous readers without separate transactions.)
>
> Absolutely, you're right. All "threads" mu
On Mon, 2006-08-07 at 16:57 -0500, Ron Johnson wrote:
> > Attach X tape drive, put in a bunch of tapes, and just pg_dump > mdt0
> > and you're backing up. Restore the other way around.
>
> Tape RAID? I like that
>
> If the disk system can keep the tape system full, though.
>
What situatio
I'm getting the following error on PGSQL 8.0.8 server that I admin. I
don't think this is a hardware problem but I'm not sure. Anyway in the
logfile I'm constantly getting this:
ERROR: xlog flush request 2/13CEA8AC is not satisfied --- flushed only
to 2/13634EE4
CONTEXT: writing block 342
I'm doing some tests with version 8.1.4 on Windows XP and am having
trouble recovering some disk space.
The tests involve loading some largeish CSV files in via COPY. One
of the COPY commands failed and I'm trying to recover the disk space
without having to completely reinitialize things.
D
Tom et al ~
I understand that this is all a risky business. So maybe someone can tell
me a safer way to accomplish what I was trying to accomplish with pg_dump
and data-only pg_restore.
It's a basic bit of database administration work. I'm trying to establish
two (or if necessary more) instance
On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote:
> I'm doing some tests with version 8.1.4 on Windows XP and am having
> trouble recovering some disk space.
>
> The tests involve loading some largeish CSV files in via COPY. One
> of the COPY commands failed and I'm trying to reco
Ken Winter wrote:
Tom et al ~
I understand that this is all a risky business. So maybe someone can tell
me a safer way to accomplish what I was trying to accomplish with pg_dump
and data-only pg_restore.
It's a basic bit of database administration work. I'm trying to establish
two (or if nec
Ken Winter wrote:
It's a basic bit of database administration work. I'm trying to establish
two (or if necessary more) instances of the same database - a production
instance and a development instance - and a change management process for
coordinating them. As you can probably guess:
You ne
Matt writes:
> I'm getting the following error on PGSQL 8.0.8 server that I admin. I
> don't think this is a hardware problem but I'm not sure. Anyway in the
> logfile I'm constantly getting this:
> ERROR: xlog flush request 2/13CEA8AC is not satisfied --- flushed only
> to 2/13634EE4
> CON
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote:
>> DROP TABLESPACE x returns 'tablespace "x" is not empty', but if I
>> examine the 'referenced by' tab in pgAdmin nothing is listed. The
>> tablespace directory contains several very large
"Ken Winter" <[EMAIL PROTECTED]> writes:
> ...
> So, the process I have in mind goes like this:
> ...
> 3. At the end of the release cycle, empty all the data from the development
> instance, shut down the production instance (or at least write-lock up its
> data), and copy the production data (dat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis wrote:
> On Mon, 2006-08-07 at 16:57 -0500, Ron Johnson wrote:
>>> Attach X tape drive, put in a bunch of tapes, and just pg_dump > mdt0
>>> and you're backing up. Restore the other way around.
>> Tape RAID? I like that
>>
>> If the di
I haven't had issues about the max_fsm_pages. The problem I had was caused
because I was not committing (or rolling back) after JDBC select calls.
I didn't think that was necessary because the select calls didnt modify
database. But, once I modified my selects to rollback after the
data is read fro
Hello to wholes, I am new therein and I am
going by of mysql to postgres,somebody serious so kind to explain me as I can
obtain in an array the names of the draws of a given base of data in PostGres.
am programming in PHP, sorry for my English, i speak spanish.thank you
very much.
Ej. V
Tom Lane wrote:
Matt writes:
I'm getting the following error on PGSQL 8.0.8 server that I admin. I
don't think this is a hardware problem but I'm not sure. Anyway in the
logfile I'm constantly getting this:
ERROR: xlog flush request 2/13CEA8AC is not satisfied --- flushed only
to 2
I am using PostgreSQL 8.1 and pgAdmin III 1.4.6 on Windows XP. When I try to
create a new SLONY-I cluster from pgAdmin -> Replication, it displays a
message below on the dialog box, "SLONY-I scripts not installed".
Please let me know from where to install these scripts and how to use
clustering f
"Matthew T. O'Connor" writes:
> Here is what I find in pg_xlog:
> [EMAIL PROTECTED] pg_xlog]# ls -l
> total 114840
> -rw--- 1 postgres postgres 16777216 Aug 7 18:29
> 000100020016
So are you still getting the error? This looks like your WAL is now
up to 2/16xx, so that s
There is no official free replication solution for Windows yet. The
next version of Slony is to have it. If you wish to test it see
http://people.planetpostgresql.org/xzilla/index.php?/archives/200-Alpha-testing-Slony-on-win32-Crib-Notes.html
for how it can be installed on windows.
Mike
On Mon,
I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
I do not have any DUMP or other backups. I want to use this folder instead
of the newly created DATA folder after new installtion.
I tried replacing the new folder with the old folder, but it did not work.
pgAdmin also
# [EMAIL PROTECTED] / 2006-08-07 22:17:26 -0700:
>
> I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
> I do not have any DUMP or other backups. I want to use this folder instead
> of the newly created DATA folder after new installtion.
>
> I tried replacing the new f
77 matches
Mail list logo
