Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

Yes, that was the results of our tests ... It seems we'll have to do a lot of work on the application to separate the queries in order to achieve the load-balancing. Thanks anyway, Best regards, Paulo Correia On 17/05/12 09:32, Sumit Raja wrote: Unsure you can achieve this without a

Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

th no connection pool? Best regards, Paulo Correia On 15/05/12 09:01, Sumit Raja wrote: On 14 May 2012 17:28, Paulo Correia wrote: Hello all! Having a Postgres 9.0 with assynchronous streaming replication to a hot-standby slave, both with CentOs 5.6, how can I use both DB instances for query

Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

disruptive with the existing pool on the application servers. Has anyone had this issue before? Any suggestions? Best regards, Paulo Correia On 13/04/12 14:38, Paulo Correia wrote: Hi! I have a Postgres 9.0 on CentOs 5.6 with a functional asynchronous streaming replication to a hot-sta

[GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

or a Tomcat server, using the server connection pooling facilities and from that we would access the database, or the balancer. Has anyone managed to do this with pgPool-II? Any other options? Best regards, Paulo Correia -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Expanding a VARCHAR on a large table that has inherited subtables ...

1. set inheritance as before of sub-table to main table 2. drop the constraint on table and subtables, apply the alter table alter column and add the constraint again 3. any other way? Best regards, Paulo Correia

[GENERAL] Postgres 8.3 erro on shared memory windows

Hi All, Anyone knowns how to start postgres on win 2003 r2 with 2 GB of shared memory on O.S with 8GB. ERROR FATAL: could not create shared memory segment 5 Failed system call was MapViewOFFileEx I try use PAE : /PAE /3GB but not sucessed. Regards Paulo

[GENERAL] Res: [ADMIN] Cluster with LATIN1 and UTF-8

--version psql (PostgreSQL) 8.3.5 on this version in another server, it's working.. but I cant repeat on postgres 9 . Paulo De: Gabriele Bartolini Para: paulo matadr Cc: admin Enviadas: Segunda-feira, 13 de Dezembro de 2010 13:11:20 Assunto: Re: [

[GENERAL] Cluster with LATIN1 and UTF-8

Hi all, Im try install postgres 9.0 on rhel and I try install cluster with 2 options of databases LATIN1 and UTF-8. It's possible? Paulo

[GENERAL] restore In parallel postgres 9

Hi gurus, When I try to pg_restore -d teste -v -j 16 < teste.dmp 2>> teste.log & I give error: pg_restore: opção inválida -- j Tente "pg_restore --help" para obter mais informação. How can using parallel resource in new postgres? Regards Paulo

[GENERAL] How to remove "enter" or new line

Hi Gurus, How to remove "enter" or new line from varchar field, I believed be chr(10) and chr(13). Regards Paulo

[GENERAL] Help on update.

test x set x.j = x.j + (select lag_j from (select i, j, nvl(lag(j) over (order by i,j) ,0) as lag_j from test) y where x.i = y.i and x.j = y.j) how can translate this for work in postgres? Thanks's Paul Paulo

[GENERAL] Invitation to connect on LinkedIn

LinkedIn Paulo moraes requested to add you as a connection on LinkedIn: -- Andrew, I'd like to add you to my professional network on LinkedIn. - Paulo Accept invitation from Paulo moraes http://www.linkedin.

Res: [GENERAL] count with high allocation

postgres=# show shared_buffers; shared_buffers 16GB (1 row) postgres=# show work_mem; work_mem -- 5MB (1 row) De: Pavel Stehule Para: paulo matadr Cc: pgsql-general@postgresql.org Enviadas: Quarta-feira, 7 de Abril de 2010 13:51

Res: [GENERAL] count with high allocation

with set enable_hashagg to off , I give the same allocation. De: Pavel Stehule Para: paulo matadr Cc: Tom Lane ; GENERAL Enviadas: Quarta-feira, 7 de Abril de 2010 12:10:23 Assunto: Re: [GENERAL] count with high allocation please, EXPLAIN ANALYZE and try

Res: [GENERAL] count with high allocation

=4) -> Seq Scan on atendimento_relacao_tipo art (cost=0.00..1.03 rows=3 width=4) "TOP" PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 26809 postgres 16 0 16.5g 8.6g 8.6g S1 27.5 1:28.84 postgres: user database 10.1.1.7(54033) SELECT _______

[GENERAL] count with high allocation

Hi all, Monitoring "top" in database server , i could noticed an query with reserved 8GB on physical memory. select count(field) from big_table 1 inner join big_table2... There is the possibility of using another function with less memory allocation? Is there a way to limit the memory usage

Enc: Res: [GENERAL] COPY ERROR

Now attached. - Mensagem encaminhada De: paulo matadr Para: Albe Laurenz Cc: GENERAL Enviadas: Quarta-feira, 31 de Março de 2010 11:03:01 Assunto: Res: [GENERAL] COPY ERROR Txt file, I belive that file not put \n on the end of line,this is possible? follow example in attach

Res: [GENERAL] COPY ERROR

Txt file, I belive that file not put \n on the end of line,this is possible? follow example in attach. De: Albe Laurenz Para: paulo matadr *EXTERN* ; GENERAL Enviadas: Terça-feira, 30 de Março de 2010 4:03:51 Assunto: Re: [GENERAL] COPY ERROR paulo

[GENERAL] COPY ERROR

Hi all, When I try to import big file base.txt( 700MB),I get this: x=# create table arquivo_serasa_marco( varchar(3000)); x=# COPY arquivo_serasa_marco from '/usr/local/pgsql/data/base.txt'; ERROR: literal newline found in data HINT: Use "\n" to represent newline. CONTEXT: COPY arquivo

[GENERAL] recovery mode

Hi all, my database entered in recovery mode last week, analyzing log file of server found this error: cat /var/log/menssages kernel: postmaster[1023]: segfault at fff0 rip 0060d993 rsp 7fff15f53c28 error 4 which means that? att Paul _

[GENERAL] recovery mode

Hi all, my database entered in recovery mode last week, analyzing log file of server found this error: cat /var/log/menssages kernel: postmaster[1023]: segfault at fff0 rip 0060d993 rsp 7fff15f53c28 error 4 which means that? att Paul __

[GENERAL] details locks

Im work with postgres my questions is,its possible on postgres: for example procpidLocker object_locked user_lockedtypeof lock comand 1 admin fooadmin2 exclusive update... thnks for all _

Enc: Res: [GENERAL] Function for replace

- Mensagem encaminhada De: paulo matadr Para: Sam Mason Enviadas: Quinta-feira, 20 de Agosto de 2009 21:57:29 Assunto: Res: [GENERAL] Function for replace because my application give error when try to reregister  some   features. I have a  many cases that use this  feature

[GENERAL] Function for replace

Hi all, In my database recently change backslash_quote to safe_enconding, now a need replace characters blocked to space or nothing. I think create a function to scan every table in database, anybody make a similar work or have this made? thanks

[GENERAL] pgstatindex

Hi all, I have been watching this field (index_size) , and see probable bug on size . anybody may explain me how fix it? select * from pgstatindex('micromedicao.xfk8_consumo_historico'); version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | del

[GENERAL] Table as parameter

at this is a sintax error, exactly at $1 position! Somebody can help me? Thank you for taking the time! Best Regards, Alex Paulo.

[GENERAL] Understand this error

kernel: Out of memory: Killed process 6519 (postmaster). How prenvent postgres use all memory of system?Why this happen? Thanks for all Paulo Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[GENERAL] Error stranger

I get this error when make a select below "SELECT * FROM batch.funcionalidade_iniciada where proi_id = x" ERROR: missing chunk number 0 for toast value 458755 SQL state: XX000 Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[GENERAL] UTF8, LATIN1 conversion problems

o something like: => select f0601_desc from f0601 where to_ascii(convert(f0601_desc::bytea, 'UTF8', 'LATIN1')::text,'LATIN1') like 'a'; gives: (0 registro) What should I do? I'm thinking create a DB with LATIN1 encoding, but UTF8 is better (should be :) ). Thanx for help. []'s Paulo Angelo

[GENERAL] Report all Comments

Hi all, i need make a report of all comments in the all tables. Where postgres storage it? Thanks Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[GENERAL] idle users

I need to procedure to kill users in idle,anybody have this made? thanks Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[GENERAL] Query for describe locks

hi ALL. i want refine this query : select pg_stat_activity.current_query , pg_class.relname, pg_locks.transaction, pg_locks.mode, pg_locks.granted, pg_stat_activity.procpid from pg_stat_activity,pg_locks left outer join pg_class on (pg_locks.relation = pg_class.oid) where pg_locks.pid=pg

Res: [ADMIN] [GENERAL] bytea size limit?

e: Albe Laurenz Para: paulo matadr *EXTERN* Cc: GENERAL ; admin Enviadas: Quinta-feira, 22 de Janeiro de 2009 6:26:26 Assunto: Re: [ADMIN] [GENERAL] bytea size limit? Please don't top post. paulo matadr wrote: >>> My aplication return erro: >>> >>> 2

Res: [ADMIN] [GENERAL] bytea size limit?

,if this bigger , hangs . No able to select or others report in this table. De: Albe Laurenz Para: paulo matadr *EXTERN* ; pgsql-general@postgresql.org; admin Enviadas: Quarta-feira, 21 de Janeiro de 2009 14:03:17 Assunto: Re: [ADMIN] [GENERAL] bytea

Res: [ADMIN] [GENERAL] bytea size limit?

My system have very large ram size, so its possible review postgresql.conf ? De: Kenneth Marshall Para: Grzegorz Ja??kiewicz Cc: paulo matadr ; pgsql-general@postgresql.org; admin Enviadas: Quarta-feira, 21 de Janeiro de 2009 11:06:23 Assunto: Re: [ADMIN

[GENERAL] bytea size limit?

I everyone, need help!!! My aplication return erro: 2009-01-20 10:22:03,264 INFO [STDOUT] Caused by: org.postgresql.util. PSQLException: ERROR: invalid memory alloc request size 1705447581 TABLE batch.relatorio_gerado rege_id integer NOT NULL, fuin_id integer NOT NULL, rela_id integer NO

Res: [GENERAL] How can I look at a recursive table dependency tree?

In postgresql 8.2 ,how find it? De: Richard Huxton Para: Ivan Sergio Borgonovo Cc: pgsql-general@postgresql.org Enviadas: Segunda-feira, 19 de Janeiro de 2009 14:36:46 Assunto: Re: [GENERAL] How can I look at a recursive table dependency tree? Ivan Sergio B

[GENERAL] Erro in vaccum

My vacuum was follow error below: WARNING: oldest xmin is far in the past HINT: Close open transactions soon to avoid wraparound problems. No have transactions in locked , what's could be happen? Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados

[GENERAL] Urgente error in restore prod

Hi guys, i need urgent help with this error: pg_restore: [archiver (db)] error returned by PQputCopyData: cannot allocate memory for output buffer im my restore . any idea with solve this error? Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados http

[GENERAL] Tool to converter plsql in pgplsql

Hi guys, you knowns a tool for automatic converter plsql in pgplsql? this tool exist? Thanks Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[GENERAL] pg_stat_activity

my querys is very biggest ,pg_stat_activity dont show full How increase length from pg_stat_activity ? Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

Res: [GENERAL] converter pgplsql funcion

(_c_clean_string, _c); end loop; return _c; end; $$ language plpgsql immutable strict; Consulta executada com sucesso sem resultados em 453 ms. De: Pavel Stehule <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL Enviadas: Sex

Res: [GENERAL] converter pgplsql funcion

her way to complete this ? De: Pavel Stehule <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL Enviadas: Sexta-feira, 21 de Novembro de 2008 10:05:02 Assunto: Re: [GENERAL] converter pgplsql funcion Hello create or replace function

[GENERAL] converter pgplsql funcion

I work with oracle and have poor experience in pg/plsql. anybody can help me with translate from pl/sql in pg/plsql in code below: CREATE OR REPLACE FUNCTION clean_string(p_dado varchar2) RETURN varchar2 IS v_clean_string varchar(4000); BEGIN v_clean_string := p_dado; for r in (sel

Res: [GENERAL] Archive files growth!!!

? De: Craig Ringer <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL Enviadas: Quinta-feira, 20 de Novembro de 2008 8:09:19 Assunto: Re: Res: Res: Res: [GENERAL] Archive files growth!!! paulo matadr wrote: > teste=#

Res: Res: Res: [GENERAL] Archive files growth!!!

ATE RESTRICT ON DELETE RESTRICT thanks De: Craig Ringer <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL Enviadas: Segunda-feira, 17 de Novembro de 2008 21:27:27 Assunto: Re: Res: Res: [GENERAL] Archive files growt

Res: Res: [GENERAL] Archive files growth!!!

result for your query "cliente_fone" 341130 3345 26760k De: Craig Ringer <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL Enviadas: Sábado, 15 de Novembro de 2008 5:53:12 Assunto: Re: Res: [GENERAL] Archive files g

[GENERAL] Enc: Help to replace caracter

I Need to replace string (" ) in the situation below : select clie_nmclientefrom cadastro.cliente where clie_nmcliente like '%"%'; result: JOANA D"ARCALMEIDA" EMLURB "P M R." CECILIA D"CAGNO" HELENA FERREIRA D"FREITAS" JOSE M. "BARRACA DO BOLA" FORTE" DUNAS BAR" JOANA D"ARC R. DE SO

Res: [GENERAL] Archive files growth!!!

take 226m) however continuous confused for me. how 26mega of insert generate 226mega of archive. mDe: Craig Ringer <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL Enviadas: Sexta-feira, 14 de Novembro de 2008 6:25:11 Assunto:

[GENERAL] Archive files growth!!!

How the best way to controling fast growth in my Database. atually my postgresql.conf have this: # - Checkpoints - checkpoint_segments = 15# in logfile segments, min 1, 16MB each checkpoint_timeout = 5min # range 30s-1h #checkpoint_warning = 30s # 0 is

Res: [ADMIN] [GENERAL] MAX_CONNECTIONS ??

Only kernel.shmmax have importance in this case? about kernel.shmmax it has configured not by me. De: Richard Huxton <[EMAIL PROTECTED]> Para: paulo matadr <[EMAIL PROTECTED]> Cc: GENERAL ; admin <[EMAIL PROTECTED]> Enviadas: Quarta-feira,

[GENERAL] MAX_CONNECTIONS ??

I need help to alter max_connections em my database, this parameter stay in defalt MAX_CONNECTIONS=100 I want to change for MAX_CONNECTIONS=300. about parameters below, need to change anything? 1 -sysctl.conf kernel.shmmax = 68719476736 kernel.shmall = 4294967296 # - Memory - 2-Postgresql.conf

[GENERAL] sum timestamp result in hours

select sum(age(rgat.rgat_tmencerramento, rgat.rgat_tmregistroatendimento)) from atendimentopublico.registro_atendimento rgat inner join cadastro.localidade loca on loca.loca_id=rgat.loca_id inner join atendimentopublico.solicitacao_tipo_especificacao step on step.step_id=rgat.step_id where date(rg

[GENERAL] pg_hotbackup how to

I have 3 database in my cluster , and would make backup online just one database ,atually i using pg_hotbackup --backupdir=/var/lib/pgsql/backups --datadir=/var/lib/pgsql/data but this command make a full backup in cluster. anybody help me! Tnks Paulo Moraes Novos endereços, o Yahoo

Re: [GENERAL] Search connections created per day

>> Hi there, >> >> I want to know how many connections is created simultaneously in data base >> per day. > >Do you want to know the max simo connections at any given time, or the >total connections in a given day? Assuming you want to know the max >simo connections at any given time, I think you'

[GENERAL] Search connections created per day

Hi there, I want to know how many connections is created simultaneously in data base per day. Are there some table where i can search it? All users is connected in the database with postgres user. Thanks. João Paulo Zavanela ---(end of broadcast

[GENERAL] Primary Key

Hello, How many fields is recomended to create a primary key? I'm thinking to create one with 6 fields, is much? Thanks! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] number errors

>> Hi all, >> >> When my application returns errors from database, some numbers errors is >> equals. >> Why number errors is equals? odbc driver or postgresql return this? >> >> It's run in Windows. >> >> Thanks. > >Hello, > >If you use ODBC - you should devide error from ODBC driver and errors >fr

[GENERAL] number errors

Hi all, When my application returns errors from database, some numbers errors is equals. Why number errors is equals? odbc driver or postgresql return this? It's run in Windows. Thanks. ---(end of broadcast)--- TIP 5: don't forget to increase

Re: [GENERAL] Install plJava

>João Paulo Zavanela wrote: >> >> The file pljava.dll exist in directory, why this error? >> Someone can help me? > >PL/Java has it's own mailing list here: >http://gborg.postgresql.org/mailman/listinfo/pljava-dev > >I think it is still active, bu

Re: [GENERAL] active connections

I don't understand, where I do it? >-- Mensagem Original -- >From: "Martin Gainty" <[EMAIL PROTECTED]> >To: João Paulo Zavanela <[EMAIL PROTECTED]> >Subject: Re: [GENERAL] active connections >Date: Mon, 30 Oct 2000 16:51:30 -0500 > > >ps

Re: [GENERAL] configure password

>> Hi, >> >> How I configure password to postgres user in Linux? >> I'm using trust, but I needing configure password in database. >> >> Thanks! >> >> ---(end of broadcast)--- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >>

[GENERAL] configure password

Hi, How I configure password to postgres user in Linux? I'm using trust, but I needing configure password in database. Thanks! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index s

[GENERAL] active connections

Hi, I would like to know how many active connections exist. Is necessary show the number ip of client. Please, somebody knows? Thanks! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/

Re: [GENERAL] Install plJava

>João Paulo Zavanela wrote: >> >> The file pljava.dll exist in directory, why this error? >> Someone can help me? > >PL/Java has it's own mailing list here: >http://gborg.postgresql.org/mailman/listinfo/pljava-dev > >I think it is still active, bu

[GENERAL] Install plJava

Hi there, I trying to install pljava, but I'm getting error in this command line: C:\Documents and Settings\Joao Paulo>java -cp "C:\\Program Files\\PostgreSQL\\8. 2\\share\\pljava\\deploy.jar";"C:\\Program Files\\PostgreSQL\\8.2\\jdbc\\postgr

[GENERAL] Problems with Postgres and TCP/IP Protocol

s too and I had the same problem. When I tries with pgadmin appear the hourglass and stay so. Thus I needs to close the window of program. I tried through psql and not worked again. The cursor is blinking below of command and nothing more happens. Thank you very much for any help.

[GENERAL] Error in Postgresql after a Machine Crash

[23112]  ERROR:  XLogFlush: request 102/598F8630 is not satisfied --- flushed only to 102/4D1A1DE0How do I fix this?TIA, Paulo Henrique

[GENERAL] fied separator change from the shell command line

Hello, I'm trying to change the usal "|" table field separator from the shell command line: psql -d ect -f pl_lost.sql -o pl_lost.out.txt -F "\t" -U asaadmin But it doesn't work. It keeps the same "|" separator in the output file. Can anyone please help me? I need to output to a tab separated fi

[GENERAL] Perfomance difference between 7.2 and 7.3

ference (7.2 vs. 7.3) account for all of it? Or should I start looking at other factors? As I said, both machines are almost equivalent hardware-wise, and as for the number of shared buffers, the faster machine actually has less of them (the 7.3 machine has "shared_buffers = 768", while the 7.2 one has "shared_buffers = 1024"). Paulo Jan. DDnet. ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Database design question: ugliness or referential integrity?

r, perhaps). Basically, store the deleted email accounts in another table... but then we lose the referential integrity check in "emails_log". The question is: what would you do? (I don't really like the idea of creating yet another "dead_emails_log" table pointing to &quo

[GENERAL] Hello and a question

r I should create somebody to administrate the process ? I just needed some general guidelines of what the mac installer do and what it do not do, so I can begin to work my way with postgres. TIA, João Paulo Vasconcellos ---(end of broadcast)--- TI

[GENERAL] "Tuple too big" when the tuple is not that big...

-Everytime I try to do a "\d (table)", Postgres dumps core with the "backend closed the channel unexpectedly". Any ideas? (Aside of upgrading to 7.x; we can't do that for now). Do you need any other information?

[GENERAL] RPMs for PHP accessing PostgreSQL via ODBC over RedHat

package 'php-pgsql-4.0.1pl2-9.i386.rpm'. Is there some similar RPM package to enable ODBC access in PHP4.0.1pl2? If not, how should I procceed? TIA, Paulo ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, plea

Re: [GENERAL] Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat

through ODBC just by installing some RPM (I also won't have the need to have the database and the application at different servers - they are actually residing at the same machine). Any hints? TIA, Paulo - Original Message - From: Chris <[EMAIL PROTECTED]> To: <[EMAIL PR

[GENERAL] [PHP] How to connect to PostgreSQL with phpPgAdmi

r | usecatupd | passwd | valuntil --+--+-+--+--+---++-- postgres |       26 | t   | t    | t    | t |    |  apache   |   27 | f   | f    | f    | f |    | (2 rows)       Please help!!! This shall most probably be some problem of permission, but how do I manage to make phpPgAdmin to correctly connect and access my databases?   TIA,Paulo

With which user Apache accesses PostgreSQL (was Re: [GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ???)

- Original Message - From: Uro Gruber <[EMAIL PROTECTED]> To: Paulo Parola <[EMAIL PROTECTED]> Sent: Sunday, March 04, 2001 7:14 PM Subject: Re: [GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ??? > Hi, > > Sunday, March 04, 2001, 1

[GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ???

 'su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start >/dev/null 2>&1" < /dev/null', is that right?   2) With which user shall I connect to the database? User "apache" or maybe user "nobody" ? Should I create a user 'apache' in PostgreSQL?   TIA, Paulo  

Re: [GENERAL] PostgreSQL 7.1 Linux Installation

ow to procceed? TIA, Paulo Parola [EMAIL PROTECTED] - Original Message - From: Mirko Zeibig <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 22, 2001 7:20 PM Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation > On Thu, Feb 22, 2001 at 04:07:06PM -

[GENERAL] Location of 7.1 version for download

Where can I download PostgreSQL v7.1? Please forward me to the URL where I can download it. Is there already binaries or do I have to compile it?   TIA, Paulo

[GENERAL] unions on views (workaround?)

ate a union among two views with SQL (I don't want to put this inteligence into the application).   TIA,   Paulo Parola [EMAIL PROTECTED]  

[GENERAL] PostgreSQL benchmark

Can any one comment on this: http://www.newsalert.com/bin/story?StoryId=CozDUWbKbytiXnZy&FQ=Linux&Nav=na-search-&StoryTitle=Linux

[GENERAL] initdb fail

g_database /usr/bin/initdb: line 481: 15150 Falha de segmentação (core dumped) "$PGPATH"/postgres $BACKENDARGS template1 <"$TEMPFILE" initdb failed. Removing /var/lib/pgsql. rm: não foi possível remover diretório `/var/lib/pgsql': Permissão negada Failed. Removing temp f

Re: [GENERAL] "Tuple is too big"

beyond the maximum size, while still taking technically just one byte? (Some of the inserted texts were Front Page-generated HTML, and had all kinds of tabs, return carriages and such). Paulo Jan. DDnet.

Re: [GENERAL] existing but not-existing database.

ojamon database?? > You should have deleted the database with "destroydb". Now you can edit "by hand" the pg_database table, which is the system table where the available databases are stored. Use standard SQL commands like "SELECT * FROM pg_database" and etc. to delete the entry for your database. Paulo Jan. DDnet.

[GENERAL] Miracle

he database was succesfully recovered. Thanks a lot. Paulo Jan. DDnet.

[GENERAL] Recovering data from binary files?

ments to counter him... Paulo Jan. DDnet.

[GENERAL] pg_operator corrupted... Any ideas?

and it said: "An error occured! connectDB() -- connect() failed: Operation timed out Is the postmaster running (with -i) at'pgsql.tht.net' and accepting connections on TCP/IP port '5432'?"). Paulo Jan. DDnet.

[GENERAL] System tables

lds the information about blah blah..."). Sorry for the rant-like nature of this post, but in any case... can anybody help? And while we're on this, what do people here do in cases like what I have described above? Paulo Jan. DDnet.

[GENERAL] Cannot find attribute of relation...

e pointers? Thanks in advance, Paulo Jan. DDnet.

[GENERAL] Creating numeric type by hand?

ossible causes for this error, I'd be grateful too). Paulo Jan. DDnet.

[GENERAL] Case insensitive searches

ries no matter if the user types the accent or not? In the previous case, the search should return the same values no matter if the user entered the word 'Künstler' (with accent) or if he typed 'Kunstler' (without accent). TIA, PAulo

[GENERAL] A security problem (newbie)

gh I grant access to va, it is denied because the ts table is not acessible! How can I turn around this? TIA -- Paulo ([EMAIL PROTECTED]) CREATE TABLE ts ( dep text, descr text ); INSERT INTO ts VALUES ('A','aa'); INSERT INTO ts VALU

[GENERAL] A security problem (newbie)

turn around this? TIA -- Paulo ([EMAIL PROTECTED]) CREATE TABLE ts ( dep text, descr text ); INSERT INTO ts VALUES ('A','aa'); INSERT INTO ts VALUES ('B','bb'); INSERT INTO ts VALUES ('B','x

[GENERAL] Conditioned access to a database

dptm field = "A". Is this possible? If the subject is not simple, pls just tell me which doc to read. TIA Paulo -- "Esta Ilha pequena que habitamos" Luis de Camoes (International version soon available) Paulo ([EMAIL PROTECTED])

[GENERAL] GUI

I'm new working with posgres. Is there any GUI to posgresql? TIA Paulo ([EMAIL PROTECTED])

[GENERAL] primary key attribute

in advance. Joao Paulo