[ADMIN] VACUUM Error?
Hello, I executed a Vacuum on my Postgres database. You can see the command line : /vacuumdb -f -z -v -d ccm > /tmp/vacuum.txt 2> /tmp/vacuumError.txt I used performed the vacuum. But I had error :"ERROR: Parent tuple was not found vacuumdb: vacuum ccm failed" each time I am executed the vacuum have you any idea about this error? And may be any solution ? Thanks in advance, best regard, Fabrice
[ADMIN] Can I delete all WAL logfiles if the database is shutdown without errors?
Hi, Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the database has been shut down correctly, because I lowered the number of logfiles in postgresql.conf? Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: [EMAIL PROTECTED] web: www.askesis.nl ---(end of broadcast)--- TIP 6: explain analyze is your friend
[ADMIN] New database: SQL_ASCII vs UTF-8 trade-offs
"PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005 (prerelease) (Debian 4.0.2-4)" Hi, Am having some doubts whether a new db should be with SQL_ASCII or UTF-8 encoding. We expect ALL of our data to be ASCII. At the same time, I guess, it's possible that some user may decide to get creative and enter, for example, his own name with non-ASCII chars. So, it seems that UTF-8 would be a better choise even if we plan to store only ASCII data (a lot of ASCII data though). Are there any negative effects related to the selection of UTF-8 over SQL_ASCII (e.g. size of the database, sort/like/group issues, etc)? Thanks in advance --- __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] New database: SQL_ASCII vs UTF-8 trade-offs
Am Dienstag, 7. März 2006 15:08 schrieb ow: > Are there any negative effects related to the selection of UTF-8 over > SQL_ASCII (e.g. size of the database, sort/like/group issues, etc)? If you're only planning to store ASCII data, choosing UTF-8 will not cause any additional problems. But obviously you're more future-proof that way. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] New database: SQL_ASCII vs UTF-8 trade-offs
ow <[EMAIL PROTECTED]> writes: > Are there any negative effects related to the selection of UTF-8 over > SQL_ASCII There will be a speed penalty; whether it's significant in your application is something you can only determine by experiment. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] VACUUM Error?
[EMAIL PROTECTED] writes: > But I had error :"ERROR: Parent tuple was not found What PG version is this? We recently fixed some bugs that could lead to this error. The error could only occur if you have some old open transaction(s) that could possibly still see since-updated tuples in the vacuumed table. So it'll go away if you close out open transactions. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Can I delete all WAL logfiles if the database is shutdown without errors?
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes: > Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the > database has been shut down correctly, because I lowered the number of > logfiles in postgresql.conf? All but the one holding the latest checkpoint record (pg_controldata will tell you which one that is). I'm not sure why you'd bother though. The next checkpoint should remove any excess log files, there's no need to do it manually. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Can I delete all WAL logfiles if the database is
Hi Tom, On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote: > "Joost Kraaijeveld" <[EMAIL PROTECTED]> writes: > > Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if > > the database has been shut down correctly, because I lowered the number of > > logfiles in postgresql.conf? > > All but the one holding the latest checkpoint record (pg_controldata > will tell you which one that is). I'm not sure why you'd bother though. > The next checkpoint should remove any excess log files, there's no need > to do it manually. Ah, I did not know that. I will wait and do nothing. Thanks -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: [EMAIL PROTECTED] web: www.askesis.nl ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] VACUUM Error?
Hello Tom Lane, Thank you very much for your answer!! My PG version is older than 7.3 , I know it so old and so much old.. but I can't update this version... :-(( However, could you explain me how I can close open transaction? Thanks in advance!! best regard Fabrice Tom Lane <[EMAIL PROTECTED]> 07/03/2006 15:52 A [EMAIL PROTECTED] cc pgsql-admin@postgresql.org Objet Re: [ADMIN] VACUUM Error? [EMAIL PROTECTED] writes: > But I had error :"ERROR: Parent tuple was not found What PG version is this? We recently fixed some bugs that could lead to this error. The error could only occur if you have some old open transaction(s) that could possibly still see since-updated tuples in the vacuumed table. So it'll go away if you close out open transactions. regards, tom lane
Re: [ADMIN] VACUUM Error?
If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, 07 March, 2006 3:25 pmTo: pgsql-admin@postgresql.orgSubject: Re: [ADMIN] VACUUM Error? Hello Tom Lane, Thank you very much for your answer!! My PG version is older than 7.3 , I know it so old and so much old.. but I can't update this version... :-(( However, could you explain me how I can close open transaction? Thanks in advance!! best regard Fabrice Tom Lane <[EMAIL PROTECTED]> 07/03/2006 15:52 A [EMAIL PROTECTED] cc pgsql-admin@postgresql.org Objet Re: [ADMIN] VACUUM Error? [EMAIL PROTECTED] writes:> But I had error :"ERROR: Parent tuple was not foundWhat PG version is this? We recently fixed some bugs that could lead tothis error.The error could only occur if you have some old open transaction(s) thatcould possibly still see since-updated tuples in the vacuumed table.So it'll go away if you close out open transactions. regards, tom lane!DSPAM:14,440da5fc49411673628609!
Re: [ADMIN] New database: SQL_ASCII vs UTF-8 trade-offs
--- Tom Lane <[EMAIL PROTECTED]> wrote: > ow <[EMAIL PROTECTED]> writes: > > Are there any negative effects related to the selection of UTF-8 over > SQL_ASCII > > There will be a speed penalty; whether it's significant in your > application is something you can only determine by experiment. I see... If *ALL* data is in ASCII, is it possible to just update "pg_database.encoding" to UTF-8 or will I need to recreate the db? Thanks __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] New database: SQL_ASCII vs UTF-8 trade-offs
ow <[EMAIL PROTECTED]> writes: > I see... If *ALL* data is in ASCII, is it possible to just update > "pg_database.encoding" to UTF-8 or will I need to recreate the db? It seems risky, but you could probably get away with that as long as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is really the only one that's safe with SQL_ASCII anyway ... note that already-started backends will probably fail to notice such a change. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] VACUUM Error?
Hello Andy, Thanks a lot for your answer, I'll retry with this new information! I will give you feedback when I would had made this new way ! Best regard Fabrice "Andy Shellam" <[EMAIL PROTECTED]> Envoyé par : [EMAIL PROTECTED] 07/03/2006 16:34 Veuillez répondre à <[EMAIL PROTECTED]> A <[EMAIL PROTECTED]> cc Objet Re: [ADMIN] VACUUM Error? If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 07 March, 2006 3:25 pm To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] VACUUM Error? Hello Tom Lane, Thank you very much for your answer!! My PG version is older than 7.3 , I know it so old and so much old.. but I can't update this version... :-(( However, could you explain me how I can close open transaction? Thanks in advance!! best regard Fabrice Tom Lane <[EMAIL PROTECTED]> 07/03/2006 15:52 A [EMAIL PROTECTED] cc pgsql-admin@postgresql.org Objet Re: [ADMIN] VACUUM Error? [EMAIL PROTECTED] writes: > But I had error :"ERROR: Parent tuple was not found What PG version is this? We recently fixed some bugs that could lead to this error. The error could only occur if you have some old open transaction(s) that could possibly still see since-updated tuples in the vacuumed table. So it'll go away if you close out open transactions. regards, tom lane !DSPAM:14,440da5fc49411673628609!
Re: [ADMIN] New database: SQL_ASCII vs UTF-8 trade-offs
--- Tom Lane <[EMAIL PROTECTED]> wrote: > It seems risky, but you could probably get away with that as long > as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is really > the only one that's safe with SQL_ASCII anyway ... I actually created the cluster with: test1:~# /usr/lib/postgresql/8.1/bin/initdb --pwprompt -D /var/lib/postgresql/8.1/main/ --lc-collate=POSIX test1:~# locale LANG= LC_CTYPE="POSIX" LC_NUMERIC="POSIX" LC_TIME="POSIX" LC_COLLATE="POSIX" LC_MONETARY="POSIX" LC_MESSAGES="POSIX" LC_PAPER="POSIX" LC_NAME="POSIX" LC_ADDRESS="POSIX" LC_TELEPHONE="POSIX" LC_MEASUREMENT="POSIX" LC_IDENTIFICATION="POSIX" LC_ALL= Not sure if it's going to make a difference. Thanks __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] postgresql-R
Hello, I was wondering if anybody has had much experience with postgresql-R, or being able to do database replication in a WAN environment. Basically, does anybody have any good links/docs on doing this with Solaris 9, postgresql v8.0? Thanks in advance. begin:vcard fn:louis n:gonzales;louis email;internet:[EMAIL PROTECTED] tel;home:248.943.0144 tel;cell:248.943.0144 x-mozilla-html:TRUE version:2.1 end:vcard ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] postgresql-R
On Tue, Mar 07, 2006 at 03:29:37PM -0500, Louis Gonzales wrote: > Hello, > I was wondering if anybody has had much experience with postgresql-R, or > being able to do database replication in a WAN environment. > Basically, does anybody have any good links/docs on doing this with > Solaris 9, postgresql v8.0? If I'm not mistaken, pgreplication (which I'm guessing is what you mean by postgresql-R) is part of the basis for the upcomming Slony-II. Right now, depending on what you mean by 'WAN', your best bet is probably Slony-I. If you're not doing a large update volume and the connections to your remote sites are reliable it should work OK. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] postgresql-R
Based on: Postgres based Replication Projects PG Replication Postgres-R: Dr. Kemme's Site, Paper, Publications, Replication Work, The Horus Project and Emsemble DRAGON: Database Replication based on Group Communication The Slony-1 Project PGCluster DBBalancer PostgreSQL Replicator: Tutorial, Paper, Techdocs eRServer: Techdocs DBMirror: Will be in the 7.3 contrib directory. Usogres: Techdocs From: http://gborg.postgresql.org/project/pgreplication/genpage.php?replication_research I was under the impression that "Postgres-R" - I misspelled it as "postgresql-R" - is a database clustering software. I downloaded the sources for this and it's supposed to work with "spread." I apologize if I'm mistaken? I will certainly take a look into Slony-1, as you suggest. Did you have any good links to this? Have you gone through an install on Solaris 9 w/Postgresl v8.0? WAN != LAN, where my database server is not in the same city as the target system to cluster with; for my worse case scenario, could be from east coast to west coast. Kind regards, Jim C. Nasby wrote: On Tue, Mar 07, 2006 at 03:29:37PM -0500, Louis Gonzales wrote: Hello, I was wondering if anybody has had much experience with postgresql-R, or being able to do database replication in a WAN environment. Basically, does anybody have any good links/docs on doing this with Solaris 9, postgresql v8.0? If I'm not mistaken, pgreplication (which I'm guessing is what you mean by postgresql-R) is part of the basis for the upcomming Slony-II. Right now, depending on what you mean by 'WAN', your best bet is probably Slony-I. If you're not doing a large update volume and the connections to your remote sites are reliable it should work OK. begin:vcard fn:louis n:gonzales;louis email;internet:[EMAIL PROTECTED] tel;home:248.943.0144 tel;cell:248.943.0144 x-mozilla-html:TRUE version:2.1 end:vcard ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] postgresql-R
Louis Gonzales <[EMAIL PROTECTED]> writes: > I was wondering if anybody has had much experience with postgresql-R, Postgres-R doesn't exist in any production-ready form. That software is an academic project that's based on a very old, buggy release of Postgres ... you *don't* want to use it. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] postgresql-R
Tom Lane wrote: Louis Gonzales <[EMAIL PROTECTED]> writes: I was wondering if anybody has had much experience with postgresql-R, Postgres-R doesn't exist in any production-ready form. That software is an academic project that's based on a very old, buggy release of Postgres ... you *don't* want to use it. regards, tom lane Tom, Thank you! I'll get rid of the source now. Jim Nasby, actually referred me to Slony... thanks Jim, that looks like what I want. begin:vcard fn:louis n:gonzales;louis email;internet:[EMAIL PROTECTED] tel;home:248.943.0144 tel;cell:248.943.0144 x-mozilla-html:TRUE version:2.1 end:vcard ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[ADMIN] Fwd: Question
-- Forwarded message --From: German Raul Hoyos Parravicino <[EMAIL PROTECTED]>Date: Mar 7, 2006 3:36 PM Subject: QuestionTo: [EMAIL PROTECTED] Dear Administrator: I have a problem developing a ECPG program. I am making a programa using FETCH, when the second row is sent the following message appear: ==>sqlcode [-213] msg[NULL value without indicator in line 1192.] My select is: EXEC SQL FETCH cursor_onlyweb INTO :t_token, :t_institucion, :t_usuario, :t_horasistema, :t_pan, :t_prcode, :t_amount, :t_acqinst, :t_source, :t_datosreq; Is it possible to use something similar to "isnull" in Oracle? Thanks Raul
Re: [ADMIN] Fwd: Question
On Tue, Mar 07, 2006 at 05:09:56PM -0500, German Raul Hoyos Parravicino wrote:
> I have a problem developing a ECPG program. I am making a programa using
> FETCH, when the second row is sent the following message appear:
>
> ==>sqlcode [-213] msg[NULL value without indicator in line 1192.]
[...]
> Is it possible to use something similar to "isnull" in Oracle?
Are you looking for the SQL-standard COALESCE?
test=> SELECT COALESCE('foo', 'bar');
coalesce
--
foo
(1 row)
test=> SELECT COALESCE(NULL, 'bar');
coalesce
--
bar
(1 row)
See also the ECPG documentation on using indicators to detect NULL.
--
Michael Fuhr
---(end of broadcast)---
TIP 6: explain analyze is your friend
[ADMIN] postgresql-8.0.1/Solaris 9/Readline-5.1
Hello List, I currently recompiled postgresql-8.0.1 for Solaris 9, with the --enable-thread-safety, to appease the install of Slony-I which worked wonderfully I used the following configure line: ./configure --enable-thread-safety --without-readline and the remainder of the defaults were fine. I then, make all'd and make install'd. Slony-I was a successful build as well after pointing to the new library and include folders. The issue I have is, that I actually want readline compiled in. This feature allows my command buffer to exist. My 2nd round of compiling has a more lengthy ./configure line... no matter what I use and include, I can't get the configure script to work, UNLESS I specify --without-readline I have the prebuilt 5.1 of readline from www.sunfreeware.com installed. I know where the lib and include directories are located and I'm including those with the correct command line options. I know, especially because I can get successful configures --with-perl and a few other options, where I also need to specify the lib and include folders for the features. Has anybody seen an issue with compiling "readline" into postgresql-8.0.1? The pre-built postgresql-8.0.1 from sunfreeware works WITH readline, but doesn't have --enable-thread-safety. Anyway, thanks in advance. By the way, Slony-I is really cool! begin:vcard fn:louis n:gonzales;louis email;internet:[EMAIL PROTECTED] tel;home:248.943.0144 tel;cell:248.943.0144 x-mozilla-html:TRUE version:2.1 end:vcard ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
