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
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
--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 gabriele.bartol...@2ndquadrant.it
Para: paulo matadr saddon...@yahoo.com.br
Cc: admin pgsql-ad...@postgresql.org
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
Hi Gurus,
How to remove enter or new line from varchar field, I believed be chr(10)
and
chr(13).
Regards Paulo
create table test(i number , j number);
insert into test values(1,2)
insert into test values(1,3)
insert into test values(1,4)
select * from test;
I J
-- --
1 2
1 3
1 4
My intentions:
after update
select
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
matadr saddon...@yahoo.com.br
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Quarta-feira, 7 de Abril de 2010 11:31:27
Assunto: Re: [GENERAL] count with high allocation
paulo matadr saddon...@yahoo.com.br writes:
Monitoring top in database server , i could noticed an query with
reserved 8GB
with
set enable_hashagg to off , I give the same allocation.
De: Pavel Stehule pavel.steh...@gmail.com
Para: paulo matadr saddon...@yahoo.com.br
Cc: Tom Lane t...@sss.pgh.pa.us; GENERAL pgsql-general@postgresql.org
Enviadas: Quarta-feira, 7 de Abril de 2010 12
postgres=# show shared_buffers;
shared_buffers
16GB
(1 row)
postgres=# show work_mem;
work_mem
--
5MB
(1 row)
De: Pavel Stehule pavel.steh...@gmail.com
Para: paulo matadr saddon...@yahoo.com.br
Cc: pgsql-general@postgresql.org
Txt file,
I belive that file not put \n on the end of line,this is possible?
follow example in attach.
De: Albe Laurenz laurenz.a...@wien.gv.at
Para: paulo matadr *EXTERN* saddon...@yahoo.com.br; GENERAL
pgsql-general@postgresql.org
Enviadas: Terça-feira
Now attached.
- Mensagem encaminhada
De: paulo matadr saddon...@yahoo.com.br
Para: Albe Laurenz laurenz.a...@wien.gv.at
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Quarta-feira, 31 de Março de 2010 11:03:01
Assunto: Res: [GENERAL] COPY ERROR
Txt file,
I belive that file
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
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
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
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
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
- Mensagem encaminhada
De: paulo matadr saddon...@yahoo.com.br
Para: Sam Mason s...@samason.me.uk
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
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 |
Hi all,
my database entry in mode recovery,
analyzing my pg_log I seem this:
system logger process (PID 6517) was terminated by signal 9
background writer process (PID 6519) was terminated by signal 9
terminating any other active server processes
and OS in var/logs:
kernel: [800ba475]
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
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
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
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
laurenz.a...@wien.gv.at
Para: paulo matadr *EXTERN* saddon...@yahoo.com.br
Cc: GENERAL pgsql-general@postgresql.org; admin pgsql-ad...@postgresql.org
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
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
My system have very large ram size, so its possible review postgresql.conf ?
De: Kenneth Marshall k...@rice.edu
Para: Grzegorz Ja??kiewicz gryz...@gmail.com
Cc: paulo matadr saddon...@yahoo.com.br; pgsql-general@postgresql.org; admin
pgsql-ad...@postgresql.org
,if this bigger , hangs .
No able to select or others report in this table.
De: Albe Laurenz laurenz.a...@wien.gv.at
Para: paulo matadr *EXTERN* saddon...@yahoo.com.br;
pgsql-general@postgresql.org; admin pgsql-ad...@postgresql.org
Enviadas: Quarta-feira
In postgresql 8.2 ,how find it?
De: Richard Huxton d...@archonet.com
Para: Ivan Sergio Borgonovo m...@webthatworks.it
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
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
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
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
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
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
]
Para: paulo matadr [EMAIL PROTECTED]
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Sexta-feira, 21 de Novembro de 2008 10:05:02
Assunto: Re: [GENERAL] converter pgplsql funcion
Hello
create or replace function clean_string(_p_dado varchar)
returns varchar as $$
declare
_v_clean_string
(_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 pgsql-general@postgresql.org
?
De: Craig Ringer [EMAIL PROTECTED]
Para: paulo matadr [EMAIL PROTECTED]
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Quinta-feira, 20 de Novembro de 2008 8:09:19
Assunto: Re: Res: Res: Res: [GENERAL] Archive files growth!!!
paulo matadr wrote:
teste=# \d cliente_fone
De: Craig Ringer [EMAIL PROTECTED]
Para: paulo matadr [EMAIL PROTECTED]
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Segunda-feira, 17 de Novembro de 2008 21:27:27
Assunto: Re: Res: Res: [GENERAL] Archive files growth!!!
paulo matadr wrote:
result for your query
result for your query
cliente_fone 341130 3345 26760k
De: Craig Ringer [EMAIL PROTECTED]
Para: paulo matadr [EMAIL PROTECTED]
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Sábado, 15 de Novembro de 2008 5:53:12
Assunto: Re: Res: [GENERAL] Archive files
a 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 pgsql-general@postgresql.org
Enviadas: Sexta-feira, 14 de Novembro de 2008 6:25
I Need to replace string ( ) in the situation below :
select clie_nmclientefrom cadastro.cliente where clie_nmcliente like
'%%';
result:
JOANA DARCALMEIDA
EMLURB P M R.
CECILIA DCAGNO
HELENA FERREIRA DFREITAS
JOSE M. BARRACA DO BOLA
FORTE DUNAS BAR
JOANA DARC R. DE SOUZA
ASSEMBLEIA
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
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 -
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 pgsql-general@postgresql.org; admin [EMAIL PROTECTED]
Enviadas: Quarta
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
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!
46 matches
Mail list logo
