Hi,
We're facing performance problems in a Linux box running CentOS release 5
(Final) and PostgreSQL 8.2.4. I've done some basic checks in the
configuration but everything looks fine to me. One weird behaviour I've
found is the cached size showed by the
"top" and "free" Linux commands:
top - 08:
25, 2009 at 3:28 PM, Carlos Henrique Reimer
> wrote:
> > Hi,
> >
> > We're facing performance problems in a Linux box running CentOS release 5
> > (Final) and PostgreSQL 8.2.4. I've done some basic checks in the
> > configuration but everything looks fine to
Hi,
I need to improve performance for a particular SQL command but facing
difficulties to understand the explain results.
Is there somewhere a tool could help on this?
I've stored the SQL code and corresponding explain analyze at
SQL: http://www.opendb.com.br/v1/sql.txt
Explain: http://www.open
Hi,
The following SQL join command runs the PostgreSQL server out of memory.
The server runs on a box with Red Hat Enterprise Linux Server release 6.3
(Santiago) and PostgreSQL 8.3.21.
select wm_nfsp from "5611_isarq".wm_nfsp
left join "5611_nfarq".nfe on
wm_nfsp.tpdoc = 7 where 1 = 1 and
wm_nfsp
abled triggers:
tg_nfe BEFORE INSERT OR DELETE OR UPDATE ON "5611_nfarq".nfe FOR EACH
ROW EXECUTE PROCEDURE fun_nfarq.nfe('5611', 'NFARQ')
FiscalWeb=#
On Thu, Nov 8, 2012 at 10:50 AM, Craig Ringer wrote:
> On 11/08/2012 06:20 PM, Carlos Henrique Reimer wrote:
>
Hi,
How is the best way to attach a debugger to the SELECT and identify why is
it exhausting server storage.
Thank you in advance!
On Fri, Nov 9, 2012 at 4:10 AM, Craig Ringer wrote:
> On 11/08/2012 11:35 PM, Carlos Henrique Reimer wrote:
> > Hi Craig,
> >
> > work_mem
Hi,
That is what I got from gdb:
TopMemoryContext: 88992 total in 10 blocks; 10336 free (7 chunks); 78656
used
Type information cache: 24576 total in 2 blocks; 11888 free (5 chunks);
12688 used
Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks);
12688 used
Operator class
eimer
On Tue, Nov 13, 2012 at 5:51 PM, Tom Lane wrote:
> Carlos Henrique Reimer writes:
> > That is what I got from gdb:
>
> > ExecutorState: 11586756656 total in 1391 blocks; 4938408 free (6
> > chunks); 11581818248 used
>
> So, query-lifespan memory leak.
Hi
I've a Linux box running postgresql 8.2.17 and facing some strange results
from the to_date function.
As you can see in the following tests the problem occurs when the template
used includes upper and lower case characters for the minute (Mi or mI).
Am I using the incorrect syntax or is it a
Hi,
We had by mistake dropped the referencial integrety between two huge tables
and now I'm facing the following messages when trying to recreate the
foreign key again:
alter table posicoes_controles add
CONSTRAINT protocolo FOREIGN KEY (protocolo)
REFERENCES posicoes (protocolo) MATCH SI
Seq Scan on posicoes (cost=0.00..8064108.80 rows=380245580
width=4)"
Will this work better that a pl/pgsql as you suggested? Or is there
something even betther?
Thank you!
2010/8/30 George H
> On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique Reimer
> wrote:
> > Hi,
> >
-- and use this as a
> base for
> DELETE statement...
>
> 2010/8/30, George H :
> > On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique Reimer
> > wrote:
> >> Hi,
> >>
> >> We had by mistake dropped the referencial integrety between two huge
> >&g
Hi,
I need to shrick a table with 102 GB and approximately 380.000.000 rows.
There is a vacuum full running for 13 hours and the only messages a get are:
INFO: vacuuming "public.posicoes_controles"
INFO: "posicoes_controles": found 43960 removable, 394481459 nonremovable
row versions in 133089
think another approach. Maybe a
CLUSTER can do the work. Will start a CLUSTER and see if I can check the
progress looking the size of the new table relfilenode. It will probably
have less than 102 GB.
Thank you!
2010/9/5 Alban Hertroys
> On 5 Sep 2010, at 12:13, Carlos Henrique Reimer wrote:
needs to be manually done and as any manual
operation exposed to errors.
Maybe this changed in the new PG releases but it was this way in the past.
Thank you!
On Sun, Sep 5, 2010 at 4:46 PM, Scott Marlowe wrote:
> On Sun, Sep 5, 2010 at 5:09 AM, Carlos Henrique Reimer
> wrote:
> &
Hi,
We are facing the following problem in a PG 8.2 server when trying to vacuum
one of our databases:
vacuumdb: vacuuming database "reimer"
INFO: vacuuming "pg_catalog.pg_database"
INFO: "pg_database": found 0 removable, 6 nonremovable row versions in 1
pages
INFO: index "pg_database_datname_
ccb(codtab)
"fk_tit_decb" FOREIGN KEY (codecb) REFERENCES "BRASIL".td_ecb(codtab)
"fk_tit_drem" FOREIGN KEY (codrem) REFERENCES "BRASIL".td_rem(codtab)
"fk_tit_rec" FOREIGN KEY (filrec, seqrec, parrec, subrec) REFERENCES
"BRASIL
"
Hi,
Yes, once correct schema was included in the search_path, VACUUM and ANALYZE
run fine again.
Thank you!
On Fri, Sep 10, 2010 at 11:38 AM, Tom Lane wrote:
> Carlos Henrique Reimer writes:
> > Yes, you're right! I found out a functional index using this function and
&g
Hi,
We're planning to move our postgreSQL database from one CPU box to another
box.
I'm considering an alternative procedure for the move as the standard one
(pg_dump from the old, copy dump to the new box, psql to restore in the
new) will take about 10 hours to complete. The ideia is installing
Thank you very much in advance,
Carlos
[1]: http://www.oracle.com/technology/tech/semantic_technologies/index.html
Hi,
I've a plpgsql function that when called never ends and I would like
to trace the internal function commands and see where is the problem.
How can I trace what the function is doing?
Thank you!
Carlos
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Thanks in advance,
Carlos G. Fischer
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Thanks in advance,
Carlos G. Fischer
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello,
Currently we have only one database accessed by the headquarter and two branches but the performance in the branches is very poor and I was invited to discover a way to increase it.
One possible solution is replicate the headquarter DB into the two branches.
I read about slony-i, but
I read some documents about replication and realized that if you plan on using asynchronous replication, your application should be designed from the outset with that in mind because asynchronous replication is not something that can be easily added on after the fact.
Am I right?
Reimer
__
ExactlyJeff Davis <[EMAIL PROTECTED]> escreveu:
Jim C. Nasby wrote:> Or, for something far easier, try> http://pgfoundry.org/projects/pgcluster/ which provides syncronous> multi-master clustering.> He specifically said that pgcluster did not work for him because thedatabases would be at physica
Hi,
I´m thinking to test your suggestion, basically because there are only few sites to connect, but there are some points that aren´t very clear to me.
My doubts:
1. How to make a view updatable? Using the rule system?
1. Why are inserts handled differently from updates?
2. Can not I use th
Hi,
I´m trying to post messages in the performance list but they don´t appear in the list.
Whan can be wrong?
Reimer__Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/
I would like to change to C because it will give us better performance. As it is per-cluster I would have to initib again but what will happen when the dump will be reloaded?
Some characters that we have today in the SQL_ASCII database probably can not be loaded in a LATIN1 database. Am I right
tt_teste (datfis) VALUES (
to_date('15/10/2006','DD/MM/') );
ERROR: new row for relation "tt_teste"
violates check constraint "tt_teste_datfis_check"
I´ll
appreciate any help!
Thanks in
advance!
Carlos
Reimer
w can we explain the 01:00:00 hour that the to_date function returns for
date 15/10/2006?
Thank you!
Carlos
> -Mensagem original-
> De: Andreas Kretschmer,,, [mailto:[EMAIL PROTECTED] nome de
> Andreas Kretschmer
> Enviada em: segunda-feira, 16 de outubro de 2006 13:41
&
.
Thanks in advance!
Carlos
> -Mensagem original-
> De: Tom Lane [mailto:[EMAIL PROTECTED]
> Enviada em: segunda-feira, 16 de outubro de 2006 16:27
> Para: [EMAIL PROTECTED]
> Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org
> Assunto: Re: RES: [GENERAL] Dates rej
date;
date
2006-10-15 01:00:00-02
(1 row)
Why is this offset present only for date 15/10/2006 (DD/MM/YYY)?
Carlos
> -Mensagem original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] nome de Tom Lane
> Enviada em: segunda-feira, 16 de outubro de 2006 16:2
Should it not show 2006-11-05 01:00:00-02 as happened before with date
15/10/2006 (dd/mm/)?
Am I missing something?
Thanks in advance!
Carlos
> -Mensagem original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] nome de Tom Lane
> Enviada em: segunda-feira, 16 de
restart).
Anyway, if it will not look at the /etc/localtime, how PG will discover the
DST changes?
Thank you in advance!
Carlos
> -Mensagem original-
> De: Tom Lane [mailto:[EMAIL PROTECTED]
> Enviada em: terça-feira, 17 de outubro de 2006 00:02
> Para: [EMAIL PROTECTED]
Hi Tom,
I think I´ve got it...
If you change something in the timezone file that is specified in
postgresq.conf, PG will know this changes automatically? Am I right?
Carlos
> -Mensagem original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] nome de Tom Lane
> Envia
those updates?
Thank you in advance!
Carlos
Hi,
I would like to improve the response time of the following SQL command but I
need some help to indentify where is it taking most of the processing time.
It seams that it is in the Seq Scan on tt_gra gra, but not sure. Am I right?
Can a new index help in this issue?
Thank you in advance!
e
Hi,
We have a PostgreSQL 8.0.6 cluster configured with lc_collate=pt_BR.UTF-8
and when we run the following SELECT:
SELECT substr(nomerazao,1,4),
ascii(substr(nomerazao,1,1)),
ascii(substr(nomerazao,2,1))
from spunico.unico order by nomerazao;
is returning:
substr | ascii | ascii
+-
han Szabo
> Enviada em: quarta-feira, 28 de março de 2007 19:23
> Para: Carlos H. Reimer
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Order by behaviour
>
>
> On Wed, 28 Mar 2007, Carlos H. Reimer wrote:
>
> > Hi,
> >
> > We have a PostgreSQL 8.0
standards?
Thanks in advance!
> -Mensagem original-
> De: Stephan Szabo [mailto:[EMAIL PROTECTED]
> Enviada em: quarta-feira, 28 de março de 2007 19:23
> Para: Carlos H. Reimer
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Order by behaviour
>
>
> On Wed
6.8-1) that link don't make things work anymore, I get the
error 'Unable to load libsqlpg.so' and I cannot connect with my
postgresql database.
Anyone knows how can I make my connection work again?
Thank you,
Carlos
---(end of broadcast)
Carlos Ojea Castro wrote:
Hello:
I'm trying to use kylix3 and postgresql 7.4.1.
My distro was Debian Woody, kernel 2.20.
I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2
and connection with my database get fine.
But now, using Debian Sarge Testing, kernel 2.4.27 (I
Oliver Elphick wrote:
On Wed, 2004-11-03 at 12:56 +0100, Carlos Ojea Castro wrote:
I'm trying to use kylix3 and postgresql 7.4.1.
My distro was Debian Woody, kernel 2.20.
I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2
and connection with my database get fine.
Bu
Hi,
I´m trying to restore a client cluster in my Linux box but during the restore the following error is reported:
__
DELETE 0CREATE USER '\set ON_ERROR_STOP 'true' PostgreSQL database cluster dump--\connect "template1"You are now conne
Hello, Is there a way do discover when was the last time a table or database vacuumed? Thanks in advance! Reimer
Yahoo! Acesso Grátis
Internet rápida e grátis. Instale o discador agora!
Hi, I would like to know how much clustered is a table related to some index How can I discover? Reimer
Yahoo! doce lar. Faça do Yahoo! sua homepage.
Hello, Pg_dump complains when I use the -Fc option with: pg_dump: [archiver] WARNING: requested compression not available in this installation -- archive will be uncompressed and the dump is not compressed... searching in the list I´ve found that there is something related with the zlib.
Hi, When the pg_locks view is used the internal lock manager data structures are momentarily locked and that is why I would like to know if some application is reading the pg_locks view and how many times. Is there a way to discover it? Thanks in advance! Reimer
Yahoo! Acesso Gr
Hi,
I would like to understand better the logic to determine when a xid is older
than another one.
As I could understand, the XID is always incremented, never reset. If it is
true, then we can have rows with cmin ranging
from 1 to 4.294.967.295 (2^32-1).
When xid overflows (32 bits) the next one
Thanks,
In my first question I would like to use xmin instead of cmin, even so I
could understand the logic.
Then for each XID you have 2 bilions XIDs that are considered lower than and
the other 2 bi higher than.
About row visibility: are all the rows with xmin higher than my XID be
considered
Hello,
During mass inserts, we have some locking contention in tables referenced by
foreign keys. It´s a 8.0.3 box
and I know that 8.1 solved this but I would like to know if there is an easy
and safe way to only apply this patch to 8.0.3?
Reimer
---(end of broadcast)---
Hi,
I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange
behavior during migration.
pg_dump inserted GRANT to phantom groups. They do not exist in pg_group;
When the script created by pg_dump is processed by psql during restore,
these GRANTs produce a lot of errors.
How could
ira, 5 de julho de 2006 00:42
> Para: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Phantom groups
>
>
> Carlos H. Reimer wrote:
> > Hi,
> >
> > I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange
> > behavi
Hi,
We´re looking for a replication solution that could address the following
situation: every morning our sellers connect to the master server and make a
copy of all tables they will need during the day to their laptop database.
After a day of work, with a lot of work done at their local database
Hello:
I want to display graphics from my postgresql database, but I must
choose the proper tool first.
Which one is more suitable?:
perl?
php?
pg_autodoc?
another one?
Thank you in advance,
Carlos
---(end of broadcast)---
TIP 5: Have you
Hello:
I want to display graphics from my postgresql database, but I must
choose the proper tool first.
Which one is more suitable?:
perl?
php?
pg_autodoc?
another one?
Thank you in advance,
Carlos
---(end of broadcast)---
TIP 2: you can get off
tabase diagrams.
R is a statistical package which can create a variety of graphical
outputs and there are a number of projects to integrate R with PG.
That's just a start. You might try searching freshmeat.net if these
don't meet your needs.
Cheers,
Steve
Thank you Steve, so: is PG a
ge:
Access violation at address 43A92782, accessing address 43B09774
¿Any idea?
Thank you.
Regards,
Carlos
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
ser_name' and
'password'.
What do you think?
Thank you very much for your help,
Carlos
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.
Am I missing something?
Regards,
Carlos
---(end of
Raymond O'Donnell wrote:
On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.
P
You still can tell the order even if you have holes in the key...
Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informação
E-mail: [EMAIL PROTECTED]
Fone: (51) 3342-8055
Fax: (51) 3342-4838
-Original Message-
From: Roderick A. Anderson [mailto:[EMAIL PROTECTED]]
Sent: quinta
er index on area and telefono which works as expected,
so it's not a LOCALE problem AFAIK).
--
Carlos G Mendioroz <[EMAIL PROTECTED]> LW7 EQI Argentina
---(end of broadcast)---
TIP 8: explain analyze is your friend
Great! Many thanks.
Casting the type did the trick.
Even though it is somehow clear now, I don't see why the type is (can)
not (be) inferred from the field type.
--
Carlos G Mendioroz <[EMAIL PROTECTED]> LW7 EQI Argentina
---(end o
Hi.
Has anyone ever used
erwin to connect to postgres?
I have been trying
to use erwin 3.5.2 sp2 to connect to pgsql via the latest odbc driver available
and can't get erwin do create PK and FK constraint correctly. What odbc version
should I use? 2.0 or 3.0?
Any help or report
about th
Hi.
I am
using postgres 7.0.can't_remember_the_rest and I am not able to add a FK
via alter table command. When I try to do it I get an "Feature not implemented"
error message. This is what I've been trying to do:
alter
table foo
add
constraint foo_fk
foreign key (a) references foo_2
access to
rows (if that were possible).
Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informação
E-mail: [EMAIL PROTECTED]
Fone: (51) 342-8055 / (51) 378-9056
Fax: (51) 342-4838
-Original Message-
From: Manuel Sugawara [mailto:[EMAIL PROTECTED]]
Sent: sexta-feira, 30 de março de
And I have 7.0 installed and yesterday I couldn't find COPY.
I had to use the \copy command in psql instead.
I've installed postgres from the source.
Any ideas why COPY isn't there, in the bin directory?
Ah, "man copy" works fine.
TIA,
Carlos Felipe Zirbes
DBServer
Primary, Sorry for my english !!!
Hi,
I ´m developing a several test database, for study. But I can´t create
any function, every time ERROR appears.
I write a C code in a plus2.c file
#include
int4 plus2(int4 a,int4 b)
{
return(a+b);
}
main() /* For getting *.out*/
{
}
, then I compile i
Hi,
this is a good day to ask this, or NOT??
How I can use the SET type, for to simulate the array behaivor
This type can be used for to represent a multivalued field in a table
Carlos Peralta Ramirez Thanks you
Hi,
I tried to create a function in C that receive an array X like
argument, and return ane element of him.
Here is the C code ->
#include
#include
int4 array_1(int4 x[]){
return(x[1]);
}
int4 array_2(int4 *x){
Title: bulk copy in postgresql
Hi.
Can someone please tell me if there is a tool in postgres similar to BCP?
I need to populate some tables using data from some text files and don't know how to do it.
Thanks in advance,
Carlos Felipe Zirbes
Hi,
Could anyone share experiences on using C-JDBC, HA-JDBC or SymmetricDB
to create a PostgreSQL cluster environment on distributed (different geo
locations)?
Thanks,
Edson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
Hi PostgreSQL,
I'musing PostgreSQL 9.3 running on Ubuntu Server.
Ihave a complex function to populate a big table, in order to improve
performance;data is prepared in temporary tables before it will be inserted. I
called thisfunction many times from my application, but something goes wrong
n Tue, Apr 12, 2016 at 9:22 AM, Juan Carlos Michaca Lucero
wrote:
I want to recover the dead data.
El Martes, 12 de abril, 2016 11:16:15, David G. Johnston
escribió:
On Tue, Apr 12, 2016 at 9:11 AM, Juan Carlos Michaca Lucero
wrote:
Hi PostgreSQL, I'musing PostgreSQL 9.3 running
Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?
Thanks,
Edson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-
Hash: SHA1
On 09/13/2014 08:24 AM, Edson Carlos Ericksson Richter wrote:
Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on
Linux?
Yes. It ran great for over a month but once we had some serious data
in it (multiple terrabytes) it died, more than once, and the last time
was
After a week or so since upgrade from 9.2.9 to 9.3.5 I'm very surprised
(in a good way) by the gain of performance.
Most noticeable change is the reduced contention for records by
exclusive/shared locks.
I can see increased numbers of requests fulfilled per minute (but I
can't be exact on th
On 18-09-2014 17:58, cowwoc wrote:
On 18/09/2014 4:26 PM, David G Johnston [via PostgreSQL] wrote:
"only PostgreSQL uses it" ... PostgreSQL doesn't use Java.
I don't think it makes a difference from a licensing point of view.
The point is that the JRE is not used to run multiple distinct
Dear list,
I've been searching in web for guidelines on OS (Linux) and PostgreSQL
(9.3.5) active monitoring best practices.
Can someone share experiences?
I'm inclined to look at Cacti and Nagios. Any other experiences?
Recommended books?
I don't want to use SaaS for monitoring - I'll have a c
Can someone point simple instructions on how to install pgAdmin 1.20 on
Linux Mint Rebecca (17.1 - based on Ubuntu trusty)?
Thanks,
Edson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsq
Yes, building from sources worked flawlessly, even for me (I'm not kind
a "build C apps from sources" guy).
Regards,
Edson
On 26-12-2014 17:15, Adrian Klaver wrote:
On 12/26/2014 10:41 AM, Edson Carlos Ericksson Richter wrote:
Can someone point simple instructions on how to
On 26-12-2014 22:13, Adrian Klaver wrote:
On 12/26/2014 02:16 PM, Edson Carlos Ericksson Richter wrote:
Yes, building from sources worked flawlessly, even for me (I'm not kind
a "build C apps from sources" guy).
Great that it worked for you. I have had issues with the wx
Hi!
I could not find in docs, is there any way to limit pg_base_backup
bandwidth usage?
Thanks,
Edson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
At the end, I've chosen to use the following:
trickle -u 500 -d 500 rsync --progress --partial -az ${PGDATA}/*
r...@xxx.bb.com:/var/lib/pgsql/repl-9.3/data/ --exclude
postmaster.pid --exclude postgresql.conf --exclude pg_hba.conf --exclude
pg_log
and it worked really well. This way I've
I'm maintaining async replication (streaming) between four database
servers arranged on 2 x 2.
How to query current segments allocation relative to "Wal keep
segments" in each master server?
I want to add this query to Postbix in order to monitor if the "wal keep
segments" parameter is too shor
On 05-01-2015 02:08, Michael Paquier wrote:
On Sun, Jan 4, 2015 at 1:48 AM, Edson Carlos Ericksson Richter
wrote:
How to query current segments allocation relative to "Wal keep segments" in
each master server?
What is your server version? You can have a look at
pg_stat_replicat
2013/10/2 Merlin Moncure
> On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto
> wrote:
> >
> > I need a help on postgresql performance
> >
> > I have configurate my postgresql files for tunning my server, however it
> is
> > slow and cpu resources
This is just a notice:
After installing 9.0.4 I noticed that I get pg_control version number =
903 when pg_controldata is run.
Thanks,
Carlos Sotto Maior
+55 11 8244-7899
<mailto:cso...@sistemassim.com.br> cso...@sistemassim.com.br
Sistemas Sim Serviços e Tecnologia Ltda.
rsions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.ut_mailing_client"
INFO: "ut_mailing_client": scanned 3 of 159576 pages, containing
1080857 live rows and 0 dead rows; 3 row
not pursue my doubt in wiki in the proper manner. I will surely
get more acquainted to wiki to keep this channel clean from repeated
questions.
Once again, thank you very much.
Carlos Sotto Maior
+55 11 8244-7899
cso...@sistemassim.com.br
Sistemas Sim Serviços e Tecnologia Ltda.
+55 11 5041-3086
es not exists
SQL state: 42883
Can you point what I'm doing wrong?
Thanks & Regards,
Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796
www.simkorp.com.br
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Ok, managed to get the first part working:
---
create extension dblink;
CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_validator;
CREATE SERVER simfrete02 FOREIGN DATA WRAPPER postgresql OPTIONS (host
'127.0.0
definitely missing something...
What is the way to go?
Edson.
De: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Em nome de Adrian Klaver
Enviada em: sexta-feira, 16 de setembro de 2011 23:30
Para: pgsql-general@postgresql.org
Cc: Edson Carlos Ericksson Richter
Assunto
laver
Enviada em: sábado, 17 de setembro de 2011 14:30
Para: pgsql-general@postgresql.org
Cc: Edson Carlos Ericksson Richter
Assunto: Re: RES: RES: [GENERAL] Foreign PostgreSQL server
On Saturday, September 17, 2011 5:22:35 am Edson Carlos Ericksson Richter
wrote:
> Thanks Adrian, I really m
Tried both, but they don't work for 9.1.
I want to thank Adrian, without his help I would never find the link that
confirmed the postgresql_fdw is not working.
Would be nice to make all this information clear in Foreign Data Wrapper
documentation at PostgreSQL manuals.
I wasted at least 12 hours
>From the manual, "In any case the hardware architecture must be the same
shipping from, say, a 32-bit to a 64-bit system will not work."...
I don't even believe you can copy a 64bit database into 32bit machine...
what makes warm standby impossible...
I've tried this in the past, and give up -
working.
I have a script with hundred similar lines (for other tables) without any
error, just this table.
Any hints?
Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796
Embedded Image
<http://www.simkorp.com
-hack...@postgresql.org
Assunto: Re: [GENERAL] Alter column...using failure under 9.0.4
=?iso-8859-1?Q?Bj=F6rn_H=E4user?= writes:
> Am 25.09.2011 um 17:17 schrieb Edson Carlos Ericksson Richter:
>> alter table usuario alter column ativo type smallint using (case when
>> ati
301 - 400 of 415 matches
Mail list logo
