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
2009/6/25 Clodoaldo Pinto Neto clodoaldo.pinto.n...@gmail.com:
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
/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 broadcast)---
TIP
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
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 points to).
My mistake, I was looking at /usr
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
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
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)---
TIP 3: Have you checked
14:59:43 -0300
From: Clodoaldo Pinto Neto [EMAIL PROTECTED]
To: pgsql-general postgresql.org 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
Content-Disposition: inline
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
://pgfoundry.org/mailman/listinfo/brasil-usuarios
Saudações, Clodoaldo Pinto
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
nome_da_minha_sequencia restart with
valor_atual, mas para isso eu preciso saber o valor atual das
minhas chaves primárias, aí eu parei...
Alguém pode me ajudar...
Leonardo,
Nesta lista dificilmente você vai encontrar ajuda pois o idioma aqui é
o inglês. Procure a lista em português.
Saudações, Clodoaldo
already been answered?
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
2006/7/3, Clodoaldo Pinto [EMAIL PROTECTED]:
2006/7/3, Clodoaldo Pinto [EMAIL PROTECTED]:
php can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() [a
href='function.pg-connect'function.pg-connect/a]: Unable to connect
to PostgreSQL server: could not connect
.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
2006/7/3, A. Kretschmer [EMAIL PROTECTED]:
am 03.07.2006, um 10:25:29 -0300 mailte Clodoaldo Pinto folgendes:
$conn_string = hostaddr=127.0.0.1 port=5432 dbname=dbname
^
I can connect as that user with psql:
$ psql -h localhost -U username dbname
2006/7/3, Robert Treat [EMAIL PROTECTED]:
On Monday 03 July 2006 09:25, Clodoaldo Pinto wrote:
php can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() [a
href='function.pg-connect'function.pg-connect/a]: Unable to connect
to PostgreSQL server: could
2006/7/3, Clodoaldo Pinto [EMAIL PROTECTED]:
php can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() [a
href='function.pg-connect'function.pg-connect/a]: Unable to connect
to PostgreSQL server: could not connect to server: Permission
denied\n\tIs the server
/pg_xlog
which is in sbd1 and is owned by postgres.
If is this a selinux problem, how can I configure it to let postgres
use the pg_xlog dir in /disk2 on startup?
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 4: Have you searched our list
2006/7/1, Tom Lane [EMAIL PROTECTED]:
Clodoaldo Pinto [EMAIL PROTECTED] writes:
There is a simlink in /var/lib/pgsql/data pointing to /disk2/pg_xlog
which is in sbd1 and is owned by postgres.
You need to modify the selinux policy to let the postmaster access
/disk2/pg_xlog ... by default
Since I have a database with a frequent and huge update batch, the WAL
segment file number is about 130. I suspect these files management
during the update is hurting performance. Is it likely? I'm using
Fedora Core 3 and checkpoint_segments is set to 64.
To overcome this I'm considering to make
2006/6/19, Clodoaldo Pinto [EMAIL PROTECTED]:
Since I have a database with a frequent and huge update batch, the WAL
segment file number is about 130. I suspect these files management
during the update is hurting performance. Is it likely? I'm using
Fedora Core 3 and checkpoint_segments is set
2006/4/19, Ben [EMAIL PROTECTED]:
Look into the immutable flag on function creation:
http://www.postgresql.org/docs/8.1/interactive/xfunc-volatility.html
That is what I needed to know, Thanks.
Regards, Clodoaldo Pinto
---(end of broadcast
and is guaranteed to
return the same results given the same arguments FOR ALL ROWS WITHIN A
SINGLE STATEMENT.
Is called() called from within a single statement in caller()?
Will the optimizer optimize the multiple calls (there will be about
30) to a single call?
Regards, Clodoaldo Pinto
() in the from clauses for a temporary
table created first in caller() but it refuses to build caller() with
the message ERROR: relation temp_table_name does not exist. It
does not exist in build time but it will exist in run time.
Regards, Clodoaldo Pinto
---(end of broadcast
pg_dump 8.1 only? I tried to copy the executable and
the libs but it did not work.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED
)
I had just enabled stats_command_string and in about 15 hours i will
be able to post pg_stat_activity.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
+ (pontos_7 * 30 / 7) desc, pontos_0 desc
loop
rank := rank + 1;
update usuarios_producao
set rank_30 = rank
where usuario = linha.usuario
;
end loop;
return;
end;$BODY$
LANGUAGE 'plpgsql' VOLATILE STRICT;
There is no DDL inside the functions.
Regards, Clodoaldo Pinto
or rolls back.
DELETE is slower than TRUNCATE but it won't block readers in other
transactions.
I think it is of great help. I will change it and let you know what happened.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 9: In versions
rows long.
Regards, Clodoaldo Pinto
---(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
2005/8/30, Alvaro Herrera [EMAIL PROTECTED]:
On Tue, Aug 30, 2005 at 10:18:20AM -0300, Clodoaldo Pinto wrote:
A vacuum full or a cluster is totally out of reach since each take
about one hour.
Even if you cluster/vacuum only the just-loaded table?
No, that would be much faster
30 Aug 2005 10:35:31 -0400, Greg Stark [EMAIL PROTECTED]:
Well a regular vacuum will mark the free space for reuse. If you insert or
update any records the new ones will go into those spots. Make sure you set
the fsm_* parameters high enough to cover all the updates and inserts for the
, thanks.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
? The indexes are default btree.
Otherwise the functions are behaving exactly as expected.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's
2005/8/28, Alvaro Herrera [EMAIL PROTECTED]:
On Thu, Aug 25, 2005 at 10:17:05AM -0300, Clodoaldo Pinto wrote:
It would have been better if it had picked postgresql-compat (or
whatever the name is for the package that has libpq3 in the 8.0.3
release). Probably if you install that package
-contrib
Error: Missing Dependency: postgresql-libs = 8.0.3 is needed by
package postgresql-devel
Error: Missing Dependency: libpq.so.4 is needed by package postgresql-server
Error: Missing Dependency: libpq.so.4 is needed by package postgresql
Regards, Clodoaldo Pinto
---(end
2005/8/21, Jim C. Nasby [EMAIL PROTECTED]:
On Sun, Aug 21, 2005 at 08:00:45AM -0300, Clodoaldo Pinto wrote:
Of course it would be even better if we could pass parameters to the
functions changing its behavior such as sunday/monday as the first day
or 0-1 as the first day.
FWIW, it seems
, Clodoaldo Pinto
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
2005/8/21, Stephan Szabo [EMAIL PROTECTED]:
On Sat, 20 Aug 2005, Tom Lane wrote:
Clodoaldo Pinto [EMAIL PROTECTED] writes:
I'm ordering by date just to show that sunday, the 0th day of the
week, is the last day of a given week, which is not what I need.
extract(week) follows the ISO
like extract
(yearweek) would be welcome.
Regards, Clodoaldo Pinto
---(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
, dayofweek(day);
Regards,
Clodoaldo Pinto
create table dates (date timestamp);
insert into dates values ('2005-08-08');
insert into dates values ('2005-08-09');
insert into dates values ('2005-08-10');
insert into dates values ('2005-08-11');
insert into dates values ('2005-08-12');
insert into dates
Pinto
2005/8/20, Bruce Momjian pgman@candle.pha.pa.us:
Uh, you are ordering by 'date', not column 3, try ORDER BY 3.
---
Clodoaldo Pinto wrote:
The extract (dow from date) function returns 0 for Sunday (nice).
My
create_function_update_ranking_usuarios.sql - function
postgresql.conf
To test run restorecontext.sh then testit.sh
By the way, if someone knows a better way to update a ranking table,
please let me know.
Regards, Clodoaldo Pinto
---(end of broadcast
After much work i was able to do it:
The psql script was changed to:
\o '/KakaoStats/bak/groupdup1.txt'
select
data,
usuario,
sum(pontos),
sum(wus)
from usuarios
where data = 2056
group by data, usuario
;
\o
\o '/KakaoStats/bak/groupdup2.txt'
select
,
sum(wus) as sum_wus
from usuarios
group by data, usuario;
Didn't try the create route. I have already performed the grouping. As
the table is big, each step takes very long and i don't have more time
to investigate further.
Regards, Clodoaldo Pinto
HTH
Tino
now is that the process was killed before overcommiting.
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Tue, 8 Feb 2005 09:06:38 -0200, Clodoaldo Pinto
[EMAIL PROTECTED] wrote:
I did:
# /sbin/sysctl -w vm.overcommit_memory=2
following
http://www.postgresql.org/docs/7.4/static/kernel-resources.html#AEN17068
And got the same error:
ERROR: out of memory
DETAIL: Failed on request of size
on how to avoid it?
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Mon, 07 Feb 2005 09:32:47 -0800, Joshua D. Drake
[EMAIL PROTECTED] wrote:
Any advice on how to avoid it?
Use a cursor.
Same thing using a cursor:
declare
rdata record;
begin
truncate table usuarios2;
for rdata in
select distinct on (data) data
from usuarios
loop
insert into
On Mon, 07 Feb 2005 13:51:46 -0800, Joshua D. Drake
[EMAIL PROTECTED] wrote:
Well your first email didn't explain that you were doing the below :)
In the first email I was not doing the insert. I was executing a psql script:
$ psql -e -f groupdup.psql ks2
This was the groupdup.psql script:
hours window to do it. Creating the
index alone takes about one hour...
Clodoaldo Pinto wrote:
Method 3 also relies in the row id. If no one can help I will do this:
Insert the distinct rows in a temporary table. Drop the index. Insert
into the original from the temporary.
How did i
in postgresql:
delete from test where rowid not in
(select min(rowid) from test group by a,b);
How to refer to the row id? Any better way to do it?
Regards, Clodoaldo Pinto
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go
Just tried 2.6.10-1.9_FC2 with the same bad results.
Am I the only one experiencing this? What would be special? The hardware? It
has nothing special, a popular Asus motherboard, 1GB memory, a modern Maxtor HD
and nothing else.
Clodoaldo
--- Clodoaldo Pinto [EMAIL PROTECTED] escreveu:
31
# in logfile segments, min 1, 16MB each
The log file shows only a long list of:
LOG: recycled transaction log file 010A00D0
LOG: recycled transaction log file 010A00CF
LOG: recycled transaction log file 010A00C9
...
Regards, Clodoaldo Pinto
hour.
Is there anyway to know why did it not start and prevent it to happen again?
How to configure it to write a log at system boot?
Regards, Clodoaldo Pinto
___
Yahoo! Acesso Grátis - Instale o discador do
of color.
I have the feeling (not the knowledge) of something wrong with the colors. I
blame the light blue.
Regards, Clodoaldo Pinto
___
Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora.
http
--- Együd Csaba [EMAIL PROTECTED] escreveu:
Dear Developers,
when do you plan to announce the final version of 8.0.0? As far as I can
remember it was promised by 15. dec.
Could you please point to where was it promised?
Regards,
Clodoaldo Pinto
it to the list. When one look at the manual it is very
easy to read elseif in instead of elsif.
Regards,
Clodoaldo Pinto
___
Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra
uma conta agora! http
interface then it will work.
Regards,
Clodoaldo Pinto
--- Najib Abi Fadel [EMAIL PROTECTED] escreveu:
Hi
i don't see any practical use of javascript with Postgresql, since a java
script is on the client side.
Unless you want each client machine to have its own database !
Najib
)?
Clodoaldo Pinto
___
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora!
http://br.acesso.yahoo.com/
---(end of broadcast)---
TIP 7: don't
--- Tom Lane [EMAIL PROTECTED] escreveu:
Clodoaldo Pinto [EMAIL PROTECTED] writes:
The 7.4.2 manual says the precision of a real number is 6 decimal digits.
Is it possible to force the display of more than six decimal digits of a
real number
Perhaps the extra_float_digits runtime
);
select f4, to_char(f4, 'FM999'), cast(f4 as int)
from test;
f4 | to_char | f4
-+-+-
4.87785e+06 | 4877852 | 4877852
Clodoaldo Pinto
___
Yahoo! Acesso Grátis
total in 1 blocks; 8176 free (4 chunks); 16 used
ERROR: out of memory
DETAIL: Failed on request of size 44.
CONTEXT: COPY usuarios, line 19646042: 428279 125110362 11
27
Regards,
Clodoaldo Pinto
.
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) without oids;
CREATE TABLE
ksDesenv=# insert into page (line)
values
-
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
char?
Regards,
Clodoaldo Pinto Neto
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,
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
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:
Hi all,
I'm restoring a database from 7.3.4 FC1 to 7.4.2
FC2:
[EMAIL PROTECTED
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
--- 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 ',';
to insert
in 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.yahoo.com
70 matches
Mail list logo