Re: [GENERAL] Upgrading side by side in Gentoo
no more mesages please.. Holger Hoffstaette escribió: On Thu, 13 Nov 2008 11:41:35 +0200, Andrus wrote: Greg, You need to get one of the experimental builds that include slotted support. Take a look at http://overlays.gentoo.org/proj/postgresql/wiki/ExperimentalFAQ and the page linked to by the blog article you mentioned at http://dev-zero.ch/blog/archives/6-PostgreSQL-Status.html Thank you. Please forget those pages, they are very outdated. I have SSH root access to this system over internet only and no experiences on Linux. If the system and/or the database are important, get someone who knows what they are doing. Person who installed this server has left the company. So I think it is not possible/reasonable to try change OS in this server. You don't have to do that - it would not solve anything. The main probem is the old PostgreSQL version, not the OS. Where to get ready binaries which can be copied and ran in Gentoo ? Is there any how-to pages or tips about compiling PostgreSql from source in this Gentoo ? This would do more harm than good so *don't*. No matter what you do you will have to dump the DB to upgrade it from 8.1.x anyway so some downtime is unavoidable. Depending on the contents you may even have to fix some bits of the schema since 8.3 is more strict than 8.1 in some ways. This is the hard part, and it has *nothing* to do with Gentoo; upgrading your installation is the easiest part and will only take a few minutes since it is completely automated (2 or 3 commands). If you are willing to pay for professional help feel free to email me. -h Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Table bloat and vacuum
Please, i wan't recive more mails Thanks Scott Marlowe escribió: On Wed, Nov 12, 2008 at 8:13 AM, Jack Orenstein [EMAIL PROTECTED] wrote: My application is running on 7.4. We have one huge table that drives SNIP We're in the process of upgrading to 8.3.4, so I'd appreciate any throughs on whether and how this behavior will change with the newer release. You will not believe how much faster 8.3 is, and how much easier maintenance is. You'll be like a kid in a candy store for months looking at and using all the new features in it. The improvements are enormous. Biggest difference for you is that 8.3 can do vacuums in a background method (it sleeps x milliseconds between pages), can run 3 or more threads, and autovacuum daemon is on by default. For the most part, your vacuuming issues will no longer exist. Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Upgrading side by side in Gentoo
*no more mesages please* Andrus escribió: I have separate production server running PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.4.6 (Gentoo 3.4.6-r1, ssp-3.4.5-1.0, pie-8.7.9) and want to upgrade this to something newer. I can allow some hours of downtime for upgrade at night. I have found Gentoo upgrade instructions here http://hasno.info/2008/7/31/upgrading-to-postgresql-8-3-on-gentoo I have no idea how PostgreSql is installed in this server, maybe it is compiled from source. So I'm afraid that using those instructions may corrupt the server so it will no longer come up in morning and I'm not able to fix it due to lack of allowed downtime and knowledge. So I'm planning the following strategy: 1. Create backup copy in this 8.1.4 2. Stop postmaster 3. Install latest version of PostgreSql to separate directory 4. Restore to it from backup 5. If something fails, stop new and re-start old 8.1.4 postmaster. The difficult point for me is (3). How to install latest version in gentoo side-by side so that old version is not touched? In windows it is easy: I can select other directory from installer. How to do same thing in this Gentoo ? I need also adminpack to read log files from pgAdmin. Andrus. Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Upgrading side by side in Gentoo
*can you teach me?? i don't know unsuscribe!!! please..* Raymond O'Donnell escribió: On 12/11/2008 17:37, Adriana Alfonzo wrote: *no more mesages please* You have subscribed to a mailing list, or someone has done it on your behalf. If you don't want any posts from the list, please unsubscribe. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Por favor, no quiero seguir recibiendo mensajes Tom Lane escribió: Richard Huxton [EMAIL PROTECTED] writes: If you connect via psql and then (as root, in another terminal) do: ps auxw | grep postgres you should see the backend that corresponds to your psql connection. strace -p pid should then show system calls as they are executed (assuming you have it installed). Execute the explain, and see what is output. Mine flies past, but is composed almost entirely of gettimeofday calls (10,000 of them) apart from at the very end where we get some write and send/recv calls (to print the explain results). I've heard of some people having slow gettimeofday calls, but not on linux. On the other hand, that seems to be the main difference between strace output with not in compared to in. AFAICT Sergey is complaining about the speed of EXPLAIN, *not* EXPLAIN ANALYZE. There'd only be a lot of gettimeofday calls in an EXPLAIN ANALYZE test. The whole thing doesn't make a lot of sense to me either. All the slowdown explanations I can think of would apply as much or more to the IN case... regards, tom lane Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Timestamp precission question
Por favor no quiero seguir recibiendo mensajes Vaclav TVRDIK escribió: Tom Lane wrote: Hm, I can't replicate that here --- but if you're using floating-point timestamps, as is default in 8.3, then a certain amount of machine-dependent roundoff fuzziness is not surprising. regards, tom lane Column is defined in such way: CREATE_DATtimestampnot null default now(), but in my opinion the value is already stored in the column and then my query should return same texts because they do display the same value in the same format, shouldn't they ? Thank you Vaclav Tvrdik Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Importing text file into a TEXT field
no quiero recibir mas correos de estos temas en donde no estoy incluida, gracias. Bruno Lavoie escribió: Hello Thomas, nice tool! Thanks for your help... For batch and automation purposes, I've done a small script... (check out my last post in the thread few minutes ago) Bruno Lavoie Thomas Kellerer a écrit : Bruno Lavoie, 07.11.2008 19:20: Hello, The intent is to use pdftotext and store the resulting text in datbase for full text search purposes... I'm trying to develop a mini content server where I'll put pdf documents to make it searchable. Generally, PDFs are in size of 500 to 3000 pages resulting in text from 500kb to 2megabytes... I'm also looking at open source projects like Alfresco if it can serve with ease to my purpose... Anyone use this one? Comments are welcome. If you are not bound to native Postgres tools, you might want to take a look at my SQL Workbench/J (http://www.sql-workbench.net) It can insert the contents of files (located on the client) into tables. You can either do this using an extended SQL syntax: UPDATE pdf_table SET text_content = {$clobfile=c:/temp/convertet.txt encoding=utf8} WHERE id = 42; (of course this statement can not be run with psql) You could also bulk-upload several files at one using my flat-file import. (http://www.sql-workbench.net/manual/command-import.html) Assuming the table has two columns (id, text_content), the flat file would look like this: id|text_content 1|content_1.txt 2|content_2.txt 3|content_3.txt and the import would store the content of the files not the literl 'content_1.txt' in the column text_content. You can either insert or update the content, depending on your needs. You could even store the orginal pdf file if the table contains a bytea column for the blob data. Contact me offline (contact information on my homepage) if you need help. Regards Thomas Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Ayuda
Tengo problemas para conseguir una version de postgres para un servidor solaris 9 sparc, donde puedo conseguirlo?? Ademas quiero instalar un driver ODBC para postgres en ese servidor y me tre problemas, supongo porque no tengo postgres ahi.. Agradeciendo de ante mano la respuesta, Me despido Adriana Alfonzo Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original. begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:[EMAIL PROTECTED] title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general