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 copy the datafiles to
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 3:00
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.
> --
>
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 table.
>
> Also a simple 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
> > "delete from pg_inherits where inhparent=20473" in
ar 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
> wrote:
>
&g
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.
2016-12-
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
https://github.com/darold/ora2pg/issues
owing-huge-size-in-postgres-installed-on-windows-os-tp5842522.html
> 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 (pg
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
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 o
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 tha
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 top
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 hostname
14 matches
Mail list logo
