Re: [GENERAL] Migrating plattaform

You should use pg_dump & pg_restore because datafiles of differents on architectures are incompatibles. El 9 nov. 2017 16:47, "Valdir Kageyama" escribió: > Hello, > > I need migrated the postgres from Linux on IBM Power to Oracle Linux on > SPARC. > > My doubt is possible

Re: [GENERAL] Postgres 9.6 Logical and Fisical replication

But what is your problem or error ? github's project doesn't support docker images that enable and configure logical replication. 2017-09-19 10:33 GMT+02:00 Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com>: > ++ Forwarding query to appropriate mail group. > > > On Tue, Sep 19, 2017 at

Re: [GENERAL] Conferences for a DBA?

whatever event list at this website https://www.postgresql.org/about/events/ is recommended for a postgres DBA. 2017-02-28 1:00 GMT+01:00 Nathan Stocks : > Thank you for mentioning location, Josh. > > > I should have noted that I am in the western United States. >

Re: [GENERAL] Slow queries on very big (and partitioned) table

Please share us an explain analyze of your query and \d+ of your table 2017-02-20 13:33 GMT+01:00 Job : > Hu guys, > > we have a test machine with Postgresql 9.6.1 an about 800.000.000 record > in a table. > Table is partitioned by day, with indexes on partitioned

Re: [GENERAL] Disabling inheritance with query.

You should use alter table XX NO INHERIT parent_table; 2016-12-22 9:49 GMT+01:00 Francisco Olarte : > Edmundo: > > On Wed, Dec 21, 2016 at 11:36 PM, Edmundo Robles > wrote: > > i need disable inheritance from many tables in a query like > >

Re: [GENERAL]

com>: > Dear All, > > I understood below point and i will do the same on my system. > > Can i close db session before REINDEX operation and again start db session > after REINDEX completed? > > > Regards, > Yogesh > > On Wednesday, December 21, 2016, Jaime Soler &l

Re: [GENERAL]

if you want to reduce the impact of reindex in your inserts and updates operations why don't you try drop index and CREATE INDEX CONCURRENTLY. As Alban said you I don't recommend you to execute reindex every hour, at least try to reduce the scope of the reindex to the minimal object.

Re: [GENERAL] ORA2PG HP-UX11i23 Itanium

El mar, 16-02-2016 a las 12:30 +, TROY Didier escribió: > Hi, > > I am looking for a way to get ora2pg on HP-UX11i23 with PG 9.3.2. > > Thanks in advance, > Didier TROY > AP-HP/DSI/ATI/PACT > 01 40 27 37 68 > I think you should create an issue here

Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

El mié, 18-03-2015 a las 23:05 -0700, Rajagopal NS escribió: I have installed Postgres 9.0 in my machine. When I look at Programs and Features under Control Panel, I see the Size for Postgres 9.0 is shown as 121GB. I feel neither the installation or the small postgres databases I would

Re: [GENERAL] Installation Size showing huge size in postgres installed on windows os

Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Jaime Soler Gómez HOPLA Software EnterpriseDB exclusive distributor ES/PT/IT LatAm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] reindex table deadlock

El vie, 07-11-2014 a las 10:02 -0500, Dan H escribió: Hi, I encountered a deadlock while running 'reindex table TABLE1' in postgresql version 9.2.4 The postgresql logs shows the two offending processes. 1st process was running reindex table TABLE1 waiting for AccessExclusiveLock on

Re: [GENERAL] Alternative to Multi-Master Replication with 2 Data centers??

On sáb, 2014-03-29 at 12:50 -0700, John R Pierce wrote: On 3/29/2014 11:35 AM, ethode wrote: Currently we're considering several options, of which Magic replication appears to be the top option. fixed that for you, hope that helps! kidding aside, there's no magic bullet here that does

Re: [GENERAL] A guide about some topics of Associate Certification

On mar, 2014-03-25 at 17:50 -0600, Oscar Calderon wrote: Hi Oscar, I've taked the enterprisedb trainings. Everybody have a nice day. Well, finally the place where i currently work paid me a chance to take the Associate Certification exam and i'm reviewing some topics, specifically the

[GENERAL] GSSAPI auth issue with windows 7 client, postgresql 9.2.3 linux server

Hi list, I am able to successfully authenticate a Windows server AD user with PostgreSQL 9.2.3 version from linux clients but It doesn't work with Windows client. First I logon windows 7, using a Active Directory's user, then I tried to login to postgresql 9.2.3 server with psql: psql -h