Re: [GENERAL] Fedora 11 where is plpython.so

2009-06-25 Thread Clodoaldo Pinto Neto
2009/6/25 Clodoaldo Pinto Neto : > Where can i find plpython.so in the Fedora 11 i586 rpm packages? The > postgresql-python does not have it: > > $ rpm -q --filesbypkg postgresql-python | grep plpython > $ > > http://download.fedora.redhat.com/pub/fedora/linux/releases/11/Fe

[GENERAL] Fedora 11 where is plpython.so

2009-06-25 Thread Clodoaldo Pinto Neto
Where can i find plpython.so in the Fedora 11 i586 rpm packages? The postgresql-python does not have it: $ rpm -q --filesbypkg postgresql-python | grep plpython $ http://download.fedora.redhat.com/pub/fedora/linux/releases/11/Fedora/i386/os/Packages/postgresql-python-8.3.7-1.fc11.i586.rpm There

Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC 4

2006-11-14 Thread Clodoaldo Pinto Neto
d http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.1.5%2Flinux%2Fsrpms%2Ffedora%2Ffedora-core-4%2Fpostgresql-8.1.5-6PGDG.src.rpm If you do it place the rpms where Devrim can copy them to the ftp server. Regards, Clodoaldo Pinto Neto ---(end of bro

Re: [GENERAL] plpython

2006-10-27 Thread Clodoaldo Pinto Neto
on.so: undefined symbol: Py_InitModule4_64 i am on a x86_64 linux box. couldnt comprehend the error. plpython.so is in /usr/local/pgsql/lib whats wrong? Read the thread named plpython.so Regards, Clodoaldo Pinto Neto ---(end of broadcast)---

Re: [GENERAL] plpython.so

2006-10-27 Thread Clodoaldo Pinto Neto
2006/10/27, Devrim GUNDUZ <[EMAIL PROTECTED]>: Hi, Anyway... I have uploaded new sets. SRPMs and FC5 RPMs will be in main FTP site in an hour. They are labeled as 8.1.5-4PGDG . Thanks! Clodoaldo ---(end of broadcast)--- TIP 1: if posting/read

Re: [GENERAL] plpython.so

2006-10-27 Thread Clodoaldo Pinto Neto
2006/10/27, Devrim GUNDUZ <[EMAIL PROTECTED]>: Hi, On Fri, 2006-10-27 at 11:46 -0400, Tom Lane wrote: > Also, the .so is probably in the postgresql-pl RPM not > postgresql-python, unless Devrim has moved things around when I wasn't > looking. Yeah, it is my mistake :-( I had removed plpython.so

Re: [GENERAL] plpython.so

2006-10-27 Thread Clodoaldo Pinto Neto
2006/10/27, Tom Lane <[EMAIL PROTECTED]>: "Clodoaldo Pinto Neto" <[EMAIL PROTECTED]> writes: > But I'm still with no /usr/lib/plpython.so. What am i missing? That's not where we keep it. Try /usr/lib/pgsql/plpython.so (or wherever "pg_config --pkglibdir&

[GENERAL] plpython.so

2006-10-27 Thread Clodoaldo Pinto Neto
-python which worked and installed the new version. But I'm still with no /usr/lib/plpython.so. What am i missing? Regards, Clodoaldo Pinto Neto ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Moving data to another disk

2006-10-04 Thread Clodoaldo Pinto Neto
I want to move the data directory to another disk and mantain the config files in the same place. I will change the data_directory parameter in postgresql.conf. I could just copy everything under /var/lib/pgsql/data to the other disk but I also want to clean the diretory now used thus I need to k

Re: [GENERAL] Moving data to another disk

2006-10-04 Thread Clodoaldo Pinto Neto
Date: Mon, 2 Oct 2006 14:59:43 -0300 From: "Clodoaldo Pinto Neto" <[EMAIL PROTECTED]> To: "pgsql-general postgresql.org" Subject: Moving data to another disk MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Conten

Re: [GENERAL] pg_restore: error returned by PQputline

2004-09-02 Thread Clodoaldo Pinto Neto
> --- Tom Lane <[EMAIL PROTECTED]> escreveu: > > the only mechanism I've heard of that causes this is the Linux > > kernel's > > out-of-memory killer --- see > > > http://www.postgresql.org/docs/7.4/static/kernel-resources.html#AEN17068 > > Googling for "OOM kill" will give you additional gory de

Re: [GENERAL] How copy a new line char to a file?

2004-08-11 Thread Clodoaldo Pinto Neto
ce of software to be mantained. Regards, Clodoaldo Pinto --- Clodoaldo Pinto Neto <[EMAIL PROTECTED]> escreveu: > Hi all, > > I'm trying to copy a table with a text field column containing a new > line char to a file: > > ksDesenv=# create table page(line text) witho

[GENERAL] How copy a new line char to a file?

2004-08-08 Thread Clodoaldo Pinto Neto
t * from page; line - 1stline 2ndline (1 registro) ksDesenv=# copy page to '/var/www/html/kakaostats/page.txt'; COPY But this is what the page.txt file looks like: 1stline\n2ndline What can I do to make the copy to command insert an actual new line c

Re: [GENERAL] server closed the connection unexpectedly

2004-07-17 Thread Clodoaldo Pinto Neto
anually, probably delete > the postmaster.pid file, and restart the postmaster daemon. > > Chances are that anyone trying to query the database is not able > to > > HTH > > > On Fri, 2004-07-16 at 21:05, Clodoaldo Pinto Neto wrote: > > Hi all, > > > &

[GENERAL] server closed the connection unexpectedly

2004-07-16 Thread Clodoaldo Pinto Neto
Hi all, Errors running a psql batch that has worked for weeks without a problem: $ uname -a Linux s1 2.6.6-1.435.2.3 #1 Thu Jul 1 08:25:29 EDT 2004 i686 athlon i386 GNU/Linux $ rpm -q postgresql postgresql-7.4.2-1 $ psql KakaoStats Bem-vindo ao psql 7.4.2, o terminal iterativo do PostgreSQL. sel

Re: [GENERAL] could not access file "$libdir/plpython" when restoring

2004-07-06 Thread Clodoaldo Pinto Neto
> > > I do believe python is included in the rpm versions > of postgresql that > are put on the mirrors. Did you compile it from > source? If so > recompile and add the python option. > > > > On Mon, 2004-07-05 at 20:33, Clodoaldo Pinto Neto > wrote: &g

[GENERAL] could not access file "$libdir/plpython" when restoring

2004-07-05 Thread Clodoaldo Pinto Neto
Hi all, I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2: [EMAIL PROTECTED] bak]$ pg_restore -d KakaoStats KakaoStats.dump pg_restore: [compressão de arquivo (banco de dados)] could not execute query: ERROR: could not access file "$libdir/plpython": No such file or directory The dump was ge

Re: [GENERAL] Ordering YYYY MM DD in reverse chrono order

2004-04-26 Thread Clodoaldo Pinto Neto
Did you try ORDER BY date_part('year', uu.add_date) desc, date_part('month', uu.add_date) desc, date_part('day', uu.add_date) DESC; Regards, Clodoaldo --- OtisUsenet <[EMAIL PROTECTED]> escreveu: > Hello, > > I am trying to select distinct dates and order them in the reverse > chronological

Re: [GENERAL] COPY TO order

2004-04-12 Thread Clodoaldo Pinto Neto
--- Guy Fraser <[EMAIL PROTECTED]> > If you have a 'serial' or 'bigserial' field like this : > > create table test_table ( > test_id bigserial, > data integer, > comment text > ); > > and you use : > > copy test_table (data,comment) > from '/wherever/the/file/is' > using delimiters ','; > >

[GENERAL] COPY TO order

2004-04-10 Thread Clodoaldo Pinto Neto
n the table. The lines have one only column of the type text. The pages are here: www.kakao.pop.com.br Regards, Clodoaldo Pinto Neto __ Yahoo! Messenger - Fale com seus amigos online. Instale agora! http://br.download.yaho