Re: [ADMIN] case statement to cath nulls on joined tables

Try that: SELECT address, CASE WHEN value_of_interest IS NULL THEN 'more friendly message' ELSE value_of_interest END value_of_interest >From poly_table left outer join data_table one poly_table.common_id = data_table.common_id -- Matheus de Oliveira On Fri, Feb 3, 2012 at 1

Re: [ADMIN] case statement to cath nulls on joined tables

Even better: SELECT COALESCE(value_of_interest, 'more friendly message') value_of_interest >From poly_table left outer join data_table one poly_table.common_id = data_table.common_id -- Matheus de Oliveira On Fri, Feb 3, 2012 at 1:05 PM, Matheus de Oliveira < matioli.math...@

Re: [ADMIN] postgres 9.0 date aberration in logs

To me seems that it just appended the data to your log. To avoid this set the log_truncate_on_rotation to on, but notice that it will replace the old logs. -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto Desempenho - LCAD<h

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

Wissem, Execute the command: $ pgpool -v And check if you are using the newst version, 3.1.2. If not, I recommend you to download and compile the pgpool source code by hand (it's easy). Regards, -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de

Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication

You have to install the postgresql client libraries first, it's missing. Must be something like: yum install postgresql9.1-client But I'm not sure about the right package name. Regards, -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto

Re: [ADMIN] Can't recover data from a .tar.gz file which was backed up using COPY BINARY command

Have you tried the above? COPY BINARY dailybackup FROM If so, what happened? -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/> Instituto de Ciências Matemáticas e de Computação - ICM

Re: [ADMIN] check_postgresql.pl for zabbix

Give read permissions to the group on the data directory and archives: chmod g+r -R /var/lib/pgsql/data I think just that will solve the problem, as you said that the agent is already been executed with postgres group. Regards, -- Matheus de Oliveira Bacharelado em Ciências de Computação

Re: [ADMIN] check_postgresql.pl for zabbix

Bèrto > > On 4 April 2012 12:24, Matheus de Oliveira wrote: > >> Give read permissions to the group on the data directory and archives: >> >> chmod g+r -R /var/lib/pgsql/data >> >> I think just that will solve the problem, as you said that the agent is >> a

Re: [ADMIN] psql: could not connect to server: No route to host

is a network connectivity > problem. I'd bet that there's something wrong with the VM > configuration, such that the VM host isn't connecting 192.168.1.* in one > VM to 192.168.1.* in the other. > >regards, tom lane > > Or the port is not

Re: [ADMIN] build from src extension files missing

-- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto Desempenho - LCAD<http://www.lcad.icmc.usp.br/> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/> Universidade de São Paulo - USP <http://www.sc.usp.br/&g

Re: [ADMIN] server not starting

He also nerds to change the listen_address to * at postgresql.conf.

Re: [ADMIN] Unable to reload postgresql.conf without restarting

conf? If so, the last one will be used. Regards, -- Matheus de Oliveira Analista de Banco de Dados PostgreSQL Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres

Re: [ADMIN] Unable to reload postgresql.conf without restarting

On Thu, Jan 3, 2013 at 4:02 PM, Scott Ribe wrote: > On Jan 3, 2013, at 10:30 AM, Matheus de Oliveira wrote: > > > They should have been reloaded. Have you set them by role, database or > tablespace? > > Or even, has them been set, by mistake, twice at postgresql.conf?

Re: [ADMIN] pg_upgrade with -j shows no perf improvement

isn't helping me? > > That is probably why you DID had some improvement, although so little. > I don't have sufficient disk space to efficiently test --link mode, > unless there's some way to quickly roll back to the pre-upgrade > version of the database after a --link mode upgrade has completed > successfully that I'm not seeing? > > I didn't got it. AFAIK, in link mode it would take **less** space than normal mode, not the opposite. Am I wrong? Unless you want to keep a backup of the old cluster on the same machine, but even on that case you could take this backup compressed, although the overall time would be worst. Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres

Re: [ADMIN] incomplete startup packet

nnecting. Check if you have this kind of service on your environment. You would have the same effect with nc: $ nc -zv 5432 As what you can do, if that is the case, just ignore this message, it should cause no harm. Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - M

Re: [ADMIN] Too many WAL archive files

less you have a lot of .backup files, there is no way 12000 wal file will use only 16GB, it would be 187.5GB, so this number seems wrong. Also check if you have set up archiving and if it is working, because if archive_command fails, PostgreSQL will keep the "failed on archive" files on

Re: [ADMIN] Reg. Restore

bloat or you don't have proper statics on your tables?! Please, give us the EXPLAIN ANALYZE of the queries with and without the indexes (you could use [2]), and run ANALYZE on the table before it. [1] http://www.postgresql.org/docs/9.1/static/populate.html [2] http://explain.depesz.com/

Re: [ADMIN] Reg. Restore

t here by yourself. Also, as Kevin suggested, this subject should be on another thread in performance list. > > > > > On Mon, Oct 7, 2013 at 11:04 PM, Matheus de Oliveira < > matioli.math...@gmail.com> wrote: > >> >> >> >> On Mon, Oct 7, 20