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
--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: [
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
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 *
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
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
=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
_______
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
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
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
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
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
_
- 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
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
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
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: [] out_of_memory+0x
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 pg_locks.pid=pg
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
,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
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
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
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
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
http://br.maisbus
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://br.maisbuscados.y
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
(_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
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
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
?
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=#
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
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
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
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:
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
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,
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
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
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! q
46 matches
Mail list logo