2010/11/27 Lew :
> Emanuel Calvo Franco wrote:
>>
>> I'm having this 'issue':
>>
>> coches=# select array_agg(patente order by fecha desc) from
>> dia4.infraccion limit 6
71}
(1 row)
I now why it happens an how avoid it, but it's ok? Must work like this?
--
Emanuel Calvo Franco
DBA | www.emanuelcalvofranco.com.ar
Curso a distancia Nivel 1 Admin Postgres:
http://www.postgresql-es.org/node/525
--
Sent via pgsql-general mailing
gres
- redundance or good backups.
You can not spare RAM or CORES. What will tell you, the exact amount
of each other,
is 'how' the application will use the base.
If you share more details, maybe we could help a little more.
--
Emanuel Calvo Franco
DBA | www.
s?
>
> The worry part is how this happened?!
>
Do you have fsync turned off?
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
Join: http://www.thevenusproject.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
use E'string'.
In that case the ' will be include into the string, so it will be not more
1 char lenght.
Or something like this:
select ('(' || quote_literal('b') || ',0)')::y
> shs-dev=# select ('("b,",0)'::y).c;
> ERROR: value
some
enhacements (cosmetic at all) here:
http://desarrollos.siu.edu.ar/trac/postgresql/attachment/wiki/Desarrollos/pgstat
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgr
es=# COPY tabla_2 FROM '/tmp/returnes.csv' DELIMITER '|';
COPY 19780
postgres=# SELECT * from tabla_2 limit 1;
entero
----
13
(1 row)
Obviusly, you can automatize these steps in a shell script.
Hope you enjoy it.
--
Emanuel Calvo Franco
DBA
2009/10/8 Leonardo M. :
> On jue, 2009-10-08 at 17:01 -0300, Emanuel Calvo Franco wrote:
>> > select
>> > *
>> > from my_table
>> > where
>> > cast(rtf_field as varchar) like '%condition%'
>> >
>> > This works ok
Dollar quoting is more clean to put strings inside than ' '. ~~ is
like operator.
And :: operand is more clean to the syntax of the query.
Don't think so? :)
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
h function.
The option
--with-wal-segsize=SEGSIZE
set WAL segment size in MB [16]
when you compile postgresql allow you to change the size of these files (but you
can't do it only restarting :S )
--
Emanuel Calvo Franco
DB
7;0.06');
Without hashtext:
CREATE INDEX xx ON table (substring(citext_col,1,4));
explain select * from pp where substring(i,1,4) = '0.06';
The entire field to search:
CREATE INDEX xx ON table (hashtext(citext_col));
explain select * from pp where hashtext(i) = hashtext('all the
2009/9/2 Devrim GÜNDÜZ :
> Hi,
>
> On Wed, 2009-09-02 at 13:47 -0300, Emanuel Calvo Franco wrote:
>> > I released initial version of my PostgreSQL 8.4 live CD, which i
>> > based on CentOS 5.3. It includes the PostgreSQL related packages
>> > that I build on h
get work 8.4:libsdl-perl,
libperl-dev, python-all-dev (for perl and python). For 8.3 i didn't
need it (seems).
But in my case i use 2.5. Hope it helps :S
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-genera
e for pgadmin
- has several docs in html format, in a /var/www and when the livecd
starts, firefox displays the links for each doc (all the docs are
in the cd, thats is the better)
- has a postgres wall paper
Could be great add-ons, what do you think about it? if i can help let
me know.
Regards!
oxy queries to different
> instances of postgres?
>
You can use dblink. But could interference the performance
and is not really what you want.
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
t
any more. but sounds charm for me. If i can offer some code
let me know :)
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
t it, if you have problems, i'll try to help again :)
The error is telling you that could not return an array into
integer.
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-g
ng to understand why happens
and not look for another way :)
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
8765 | 571112
168773 | 168766 | 992462
168774 | 168767 | 992471
(5 filas)
synchronize_seqscan are on in both engines.
I only want to know why is this difference...
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanu
nnot find include file:
>> "xpath.c", line 21: cannot find include file:
>> "xpath.c", line 22: cannot find include file:
>
> You need to tell configure where to find libxml's headers
> (--with-includes).
>
Ok, sounds good :)
I will try to take a
mbol: doctree
"xpath.c", line 190: cannot recover from previous errors
cc: acomp failed for xpath.c
Reaping losing child 0x080a3290 PID 1718
gmake: *** [xpath.o] Error 2
Removing child 0x080a3290 PID 1718 from chain.
The other problem was compiling uuid-opps and tablefunc contribs.
Som
his ? If not, i will continue my workaround on this and
try to propose something to fix it.
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
ArPug.com.ar / aosug.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
//www.postgresql.jp/npo/logo/?searchterm=logo
It's no bad...
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
>
> select ...
> from T
> where x > $1
>
prepare testy_prepare(int) as select * from T where x = $1;
execute testy_prepare(4);
Follow the docs :)
http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html
--
Emanuel Calvo Franco
ArPUG [www.arp
mit).
Which improvement do you want to obtain with the array way?
If the table is very small, the improvement in terms of performance
will be negligible.
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
--
Sent via p
ca/
The project is growing and have a very easy setup and administration.
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ation for Solaris are in the site #1, you will find since
installation until complex trace rutines.
Enjoy it!
#1[http://www.sun.com/software/products/postgresql/index.jsp]
Regards,
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
> so that I knew what to look for in the manual?
>
> Thank you for your time.
> Dimitry
>
You can use the function pg_read_file(text,bigint,bigint)?
like:
inser into table foo values(1,2,3 [...], pg_read_file(filename,1,[?]);
The problem is to write it on the disc, there is not a f
2009/5/29 David Fetter :
> On Fri, May 29, 2009 at 09:48:42AM -0300, Emanuel Calvo Franco wrote:
>> 2009/5/28 Kris Jurka :
>> >
>> >
>> > On Wed, 27 May 2009, Emanuel Calvo Franco wrote:
>> >
>> >> Hi community,
>> >>
>> &g
2009/5/28 Kris Jurka :
>
>
> On Wed, 27 May 2009, Emanuel Calvo Franco wrote:
>
>> Hi community,
>>
>> I'm trying to compile pl/java sources for 8.4 beta1 (for a test) but
>> it gives me 20 errors at the end:
>
> To build against 8.4 you need pljava
va_all] Error 2
..."
I have 8.3 jar compild pljava, exists a way to create a function and
the server 'ignore' the lib version?
Regards,
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
--
Sent via pgsql-gener
2009/5/27 Emanuel Calvo Franco :
> 2009/5/27 Anirban Pal :
>> Dear all members,
>>
>> I have been working on postgres (windows), for last 8 months. Recently, a
>> client requrement requires me to install postgres in solaris 10. What I did
>> is this. Untar the
sender does so expressly with
> due authority of NSTL.
>
Remember that in Solaris you have SMF to initialize Postgresql with more
'intelligence'.
Is a perfect document that describes the complete installation of Pgsql on
this platform:
http://dlc.sun.com/pdf/819-5578/819-557
;)
>
That's i call a good point XD
But i must say is not so handly ;P
> http://www.postgresql.org/docs/books/
If you look for well, you will find the book i recommended.
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
--
"postgresql handbook".
The Peter Einsertraut book is in Deustch language, but if you have intuition
you can read it :P
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
--
Sent via pgsql-general mailing list (pgsql-gen
ets large ... you'll never see it during devel testing on toy tables ...
>
> regards, tom lane
>
Yeap. If you see one of the test i made, you'll see this switch over the
~100 regs.
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
2009/5/8 David Fetter :
> On Fri, May 08, 2009 at 06:40:33PM -0300, Emanuel Calvo Franco wrote:
>>
>> I test it in the first time :)
>>
>> With the 'order by' it works well, but in 'theory'
>
> The theory under which you should operate is th
2009/5/8 David Fetter :
> On Fri, May 08, 2009 at 06:10:18PM -0300, Emanuel Calvo Franco wrote:
>> Hi all.
>>
>> I'll make this faster.
>>
>> I hace this table and this function:
>
> You should only ever assume that your SELECT's output will have
2009/5/8 Tom Lane :
> Emanuel Calvo Franco writes:
>> Executing 'select * from datos limit 1 offset 15' two times i have
>> different
>> result sets.
>
> The "synchronous scan" logic is probably responsible. Turn off
>
8.00 rows=172800 width=8)
(actual time=0.014..356.800 rows=
11 loops=1)
Total runtime: 622.247 ms
(3 rows)
That's correct? Is logical that if the scan is sequential in the
physical table returns differents
data?
I test it on 8.4 beta1 and 8.3.5 and 8.3.7 with the same results.
Thanks
a database in disk and have updatable
views in memory :)
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arpug.com.ar)
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@
.049 ms
(2 rows)
So, let's see in a brief:
standard table on ram: 22836.532
standard table on disk: 16902.042
temp table on ram: 12773.371
temp table on disk: 13716.049
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arpug.com.ar)
A
d lvalue in assignement
> warning no new line at end of file
>
> Please any direction of how to solve the problem
>
> here is the command i wrote in MinGW
>
> gcc -shared -o hamzeh.dll tt1.o -L "c:/programme/postgresql/8.3/lib"
> -lpostgres
>
try c:\programme\
Gw
>
> Thanks again
AFAIK gcc has an option -I for detail the path of the includes.
I think there must be inside a folder called 'server' in the same
path.
Yes, i was who said to you that committers is not the right place :)
--
Emanuel Calvo Franco
Sumate al ARPUG
fnction)
> error 'new_point' undeclared (first use in his function)
> error: syntax error befre ')' oken
> in function 'copy text':
> error: 'invalid lvalue in assinment
> In function 'concat_text'
> error: invalid lvalue in assignement
t;
> PG_RETURN_POINT_P(new_
> point);
> }
>
> the only function that are work are the one with int32 variable.
> the other function bring errors and are not working
> any body can give directions
>
>
> kind regards
> ihab
Re-send to pgsql-general.
Can you pas
2009/4/1 Emanuel Calvo Franco :
> 2009/4/1 Patrick Desjardins :
> Did you try to make a reindex?
>
If you get an error with that, try to drop indexes and create
again.
>
> --
> Emanuel Calvo Franco
> Sumate al ARPUG !
> (www.postgres-arg.org -
&g
x versions, i declare a var in postgresql.conf (zero_damaged_pages = on )
and make the dump with this option. I don't know if this var is in newly
versions.
Did you try to make a reindex?
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arp
of error occurs generally on 7.x versions or if you are using
fsync =off and you have a surprised system down.
Try to do a pg_dump of the database or clean (no delete) del wal files
(this is not
recommendable for new users).
> What can I do to fix that problem?
>
> Thank you,
>
--
t;
> The two servers are using different ports. I'm running v 8.3 on a
> Mac running 10.5.
>
> What's the secret step I'm missing here?
>
> Thanks,
> Eric
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make chang
e any other clever solutions of this problem?
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.po
eful.
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's RemoteDBA services!
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.p
of interest.
>> Finally, to know if there's any book (english) for the PostgreSQL
>> Certification, like in Japanese.
>>
>> Thank you for your time,
>>
>> Steve,
>>
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgr
om.ar/pgsql.vid.gz
[1] http://www.pglive.info
--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
Daniel
> PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel
ystem
> Volume Information/
>
>
>
> It should have been two rows as follows:
>
>
>
> 1180635517879 3001C:/SQLBackup/
>
> 1180635517879 3001C:/System Volume Information/
>
>
>
> Is this something that is perhaps fixed in postgresql 8.3? Any assist
t;
>
> Regards,
> Aleksander
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
I forgive to tell you that you must add operators...d'oh!
--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ely on those casts
http://code.open-bio.org/svnweb/index.cgi/biosql/revision?rev=284
here are the functions
--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
ting Fax: +49 551 489500-91
> Hans-Böckler-Straße 2 http://www.deriva.de
> D-37079 Göttingen
>
> Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make chan
27;s but not the operator.
The cast is in other way (try to compare with a text '13')
for example.
>
> Regards,
> Aleksander
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresq
stgres database?
>>
>> dbi-link
Ora-link
>
> In the opposite direction, you can use Oracle's feature described here:
> http://lists.mysql.com/mysql/189287 (change to psqlodbc driver should be
> easy).
>
>
>
>
> --
> Filip Rembiałkowski
>
--
ntly see what it does with
> many users, and how it behaves as the number of users increases.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG / AOSUG Member
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2008/12/26 Martijn van Oosterhout :
> On Fri, Dec 26, 2008 at 09:52:59AM -0200, Emanuel Calvo Franco wrote:
>> Hi people,
>>
>> Yesterday when i was making some commands on 8.3.5
>> (on Centos)
>> i found a rare behavior of limit offset.
>>
>> Try in ps
2008/12/24 Tom Lane :
> "Emanuel Calvo Franco" writes:
>> But when i want to make, i recieved an error (make and
>> /opt/SunStudioExpress/bin/dmake ):
>> "...
>> eca...@lastchance:~/Desktop/postgresql-snapshot$ sudo make
>> You must use GNU make t
from foo limitsdfsdfaerfgsafqaweawe; <- shows all rows
select * from foo limit; <- this shows error ok
select * from foo limitt;
All the chars inmediatly continue the limit or offset commands
are ignored.
If this kind of problems there isn't a bug, sorry.
--
Emanuel Calvo Franc
d for target `all'
..."
Exact Versions:
Product Version: Sun Studio (Build 200810171318, Sun Studio 20081005)
Java: 1.6.0_10; Java HotSpot(TM) Client VM 11.0-b15
System: SunOS version 5.11 running on x86; UTF-8; es_AR (sunstudio)
Userdir: /export/home/ecalvo/.sunstudio/ceres-dev4-SunOS-i386
Than
Hi !
There isn't another way to download 8.4devel that isn't
cvs and the last rpm binary?
I mean, i need source code, but in my work i can't
access with cvs because proxy policies.
Sorry for my bad english,
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG
ts of this implementation? what do you want to resolve with it?
>
> Ketema J. Harris
> www.ketema.net
> ket...@ketema.net
> ketemaj on iChat
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://w
t
know if there is a way to simmulate this.
>> Is there something I can do to make postgres works like Oracle ? I am
>> using postgres 8.1.11 on SLES10.
>>
>
> postgres grant model is different; you can't hide db structure from db
> users.
See that, that's becau
wrong.
>
> Cheers,
> Liraz
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql Con
> Cheers,
> Liraz
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
errores que pudieran afectar al
> mensaje original.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
Emanuel Calvo Franco
Syscope Postgresql
/*--
Bienvenidos a:
PGDay 2008 Rio de la Plata
Organizado por la comunidad de PostgreSQL de Bs As (BaPUG)
Web: www.postgres-arg.org
-
advance.
>> dotyet
>>
>
>
> --
> Zdenek Kotala Sun Microsystems
> Prague, Czech Republic http://sun.com/postgresql
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql DBA
BaPUG Member
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
http://slony.blogspot.com/
sorry is in spanish, but is an exelent resource,
i hope it will be useful
reggards
2008/10/27 Abdul Rahman <[EMAIL PROTECTED]>:
> May any one support step by step procedure for the replication with slony-I
> in windows xp.
>
>
--
Em
erforming a VACCUM FULL? It locks the database for several
> hours, and that is not a solution.
>
> I guess a backup-restore would do the work but, isn't there a better way to
> do this without shutting down postgres?
>
> Thanks in advandce.
>
>
--
inside psql turn \o file
then \l
2008/10/9 Jeff Ross <[EMAIL PROTECTED]>:
> Joao Ferreira gmail wrote:
>>
>> Hello all,
>>
>> I need to print to a file a simple list of all the databases on my
>> postgresql.
>>
>> I need to do this from a shell script to be executed without human
>> intervention
When i question about WAL, i mean if WAL is in other drive.
You must run a benchmark more expensive to cpu for make a conclusion.
Make a query that have more of 8 seconds, then you can see really if
exists a diference
in other way... i think you don't use the same image of the old server
in the n
How do you manage the wal in both servers?
The version kernel is the same in both?
Runs the same services?
Do you make some test with Posgresql only in both servers?
If the problem is the inter-CPU, i know you can specified the number
of processors
do you want to run dedicated to one process.
200
2008/9/27 Douglas McNaught <[EMAIL PROTECTED]>:
> On Sat, Sep 27, 2008 at 12:13 PM, Mark Mielke <[EMAIL PROTECTED]> wrote:
>> If
>> some parts of PostgreSQL are not performance bottlenecks, and they are
>> extremely complicated to write in C, and very easy to write in something
>> else common and s
Sorry Alvaro, i sent to you the message ;P
Is the same way (from snapshot) that use Mysql on ZFS.
IF you don't change anything in the database, why it don't works?
Then you restart the service with the same path.
The problem it will be that you need to stop postgres BEFORE snapshot.
--
Sent
83 matches
Mail list logo
