Re: [GENERAL] Migrating plattaform

[Jaime Soler]

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 new enviorement ? or I need
> using  other means of copying the data.
> For exemples: pg_dump/pg_restore.
>
>
> regards
>
> Tikara
>

Re: [GENERAL] Postgres 9.6 Logical and Fisical replication

[Jaime Soler]

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 AM, guedim  wrote:
>
>> Hi guys
>>
>> I am working with Postgres9.6 with a Master/Slave cluster replication
>> using
>> Streaming replication.
>> I would like to add a new Slave server database but this database with
>> logical replication .
>>
>>
>> I tried with some configurations but it was not possible  :(
>>
>> https://github.com/guedim/postgres-streaming-replication
>>
>>
>> Here is the image of what is in my mind:
>> 
>>
>> Thanks for any help!
>>
>>
>>
>> --
>> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-hackers
>> -f2155306.html
>>
>>
>

Re: [GENERAL] Conferences for a DBA?

[Jaime Soler]

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.
> --
> *From:* Joshua D. Drake 
> *Sent:* Monday, February 27, 2017 4:39:08 PM
> *To:* Nathan Stocks; pgsql-general@postgresql.org
> *Subject:* Re: [GENERAL] Conferences for a DBA?
>
> On 02/27/2017 03:25 PM, Nathan Stocks wrote:
> > What worthwhile conferences should a PostgreSQL DBA consider going to?
> >
> >
> > There have been some good sessions at OSCON in the past, but I was
> > wondering about more DBA-specific events.
>
> If you are in North America, this is the largest and it is taking place
> in a Month.
>
> http://pgconf.us/
>
> There are others such as postgresopen and next week there is a two
> track, two day set of sessions at SCALE.
>
> Sincerely,
>
> JD
>
>
> --
> Command Prompt, Inc.  http://the.postgres.company/
>  +1-503-667-4564 <(503)%20667-4564>
> PostgreSQL Centered full stack support, consulting and development.
> Everyone appreciates your honesty, until you are honest with them.
> Unless otherwise stated, opinions are my own.
>

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

[Jaime Soler]

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 (for example i want to search log occurred in a
> specific day), is immediate in tha partitioned table (table_2017_02_15) but
> *extremely* slow in global table.
>
> Where am i wrong?
> Shall i create global index?
>
> Thank you!
> /F
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Disabling inheritance with query.

[Jaime Soler]

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"  instead alter table ...
> > but  is safe?   which is the risk for  database if  i  delete it?
>
> Dangers of touching the catalog directly have already been pointed by
> TL, along with the question of why isn't normal ALTER TABLE ok.
>
> If it is because there are a lot of childs, I would like to point a
> simple script ( if you are fluent in any scripting language, or even
> in SQL ) can be used to automatically generate a bunch of alter table
> commands. Even a simple text editor will do ( turn your query above
> into something generating a bunch of table names, edit it ). Or just
> try something like ( beware, untested )
>
> with childs as (select relname from pg_class, pg_inherits where
> pg_class.oid=inhrelid and inhparent='20473)
> SELECT 'ALTER TABLE ' || relname || ' rest of alter table command;'
> from childs ;
>
> And feed the result back to the server using your favorite tool (
> quoting maybe needed, schema names may be needed, YMMV ).
>
> Francisco Olarte.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL]

[Jaime Soler]

well if you would like to cancel o terminate a session before start
inserting or updating data , you can use pg_cancel_backend or
pg_terminate_backend using pid returning from select pid pg_stat_activity
where state='active' ..

2016-12-21 13:28 GMT+01:00 Yogesh Sharma <yogeshra...@gmail.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 <jaime.so...@gmail.com>
> wrote:
>
>> 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-21 12:51 GMT+01:00 Yogesh Sharma <yogeshra...@gmail.com>:
>>
>>> Dear Alban,
>>>
>>> In my production system, there are lot of read write operation performed
>>> every hour.
>>> So, i am thinking, if i can add check during REINDEX operation nothing
>>> update and insert operation performed.
>>> Is it possible?
>>>
>>> Regards,
>>> Yogesh
>>>
>>> On Wednesday, December 21, 2016, Alban Hertroys <haram...@gmail.com>
>>> wrote:
>>>
>>>> On 21 December 2016 at 09:59, Yogesh Sharma <yogeshra...@gmail.com>
>>>> wrote:
>>>> > Also, every hour,i am performing VACUUM and REINDEX operation on
>>>> table.
>>>>
>>>> Why are you running REINDEX every hour? That's a very unusual thing to
>>>> do, you'd need a pretty good reason for that.
>>>>
>>>> --
>>>> If you can't see the forest for the trees,
>>>> Cut the trees and you'll see there is no forest.
>>>>
>>>
>>

Re: [GENERAL]

[Jaime Soler]

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-21 12:51 GMT+01:00 Yogesh Sharma :

> Dear Alban,
>
> In my production system, there are lot of read write operation performed
> every hour.
> So, i am thinking, if i can add check during REINDEX operation nothing
> update and insert operation performed.
> Is it possible?
>
> Regards,
> Yogesh
>
> On Wednesday, December 21, 2016, Alban Hertroys 
> wrote:
>
>> On 21 December 2016 at 09:59, Yogesh Sharma 
>> wrote:
>> > Also, every hour,i am performing VACUUM and REINDEX operation on table.
>>
>> Why are you running REINDEX every hour? That's a very unusual thing to
>> do, you'd need a pretty good reason for that.
>>
>> --
>> If you can't see the forest for the trees,
>> Cut the trees and you'll see there is no forest.
>>
>

Re: [GENERAL] ORA2PG HP-UX11i23 Itanium

[jaime soler]

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/  , explaining all the details.

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

[jaime soler]

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 have
 created use 121GB. 
 
 Any reason why it shows 121GB 

Could you share with us \l+ command in psql session ?

 
 Regards 
 NS Rajagopla
 
 
 
 --
 View this message in context: 
 http://postgresql.nabble.com/Installation-Size-showing-huge-size-in-postgres-installed-on-windows-os-tp5842522.html
 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
 
 




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[jaime soler gómez]

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 have
 created use 121GB. 
 
 Any reason why it shows 121GB 

Could you share with us \l+ command in psql session ?
 
 Regards 
 NS Rajagopla
 
 
 
 --
 View this message in context: 
 http://postgresql.nabble.com/Installation-Size-showing-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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] reindex table deadlock

[jaime soler]

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 primary key index of TABLE1
 
 2nd process was running stored procedure that executes selects and
 deletes to TABLE1
 waiting for RowExclusiveLock on TABLE1.
 
 Is this the same lock upgrade deadlock issue that someone has
 previously mentioned with reindex?

Why don't you use create index concurrently to avoid the ACCESS
EXCLUSIVE lock and uses a SHARE UPDATE EXCLUSIVE lock?
 
 




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[jaime soler]

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 what you describe 
 without introducing its own complex set of problems and performance 
 issues, not the least of which is transaction conflict resolution.

checkout xDB Replication Server v5.0 Multi-Master
http://www.enterprisedb.com/products-services-training/products-overview/xdb-replication-server-multi-master
maybe it adjust to your requirements.



 
 
 
 
 -- 
 john r pierce  37N 122W
 somewhere on the middle of the left coast
 
 
 




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[jaime soler]

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 topics that the exam covers
 (some of them are easy to me like psql, which i use almost everyday)
 but i have doubt about 2 of the topics and i don't know if i already
 have the knowledgement about those topics.
 
 
 The topics are:
 
 
   * Postgres Data Dictionary: This is about information schema?
It's about system catalog:
http://www.postgresql.org/docs/9.3/static/catalogs.html

   * Moving Data: This is about migration? Or about moving
 tablespaces in the file system?
No. It's refer to the process of import/export data using the COPY
command:
http://www.postgresql.org/docs/9.3/static/sql-copy.html 



 Unfortunately i don't have enough money to pay for the training so i
 don't have any reference about what those topics talk about. I just
 ask for your help for a reference about what does it means each topic,
 just as a start point to read about it and practice.
 
 
 Regards.
 
 
 ***
 Oscar Calderon
 Analista de Sistemas
 Soluciones Aplicativas S.A. de C.V.
 www.solucionesaplicativas.com
 Cel. (503) 7741 7850 Tel. (503) 2522-2834




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[jaime soler]

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 -p 5444

psql: SSPI continuation error: The encryption type requested is not
supported by the KDC. (80090342)

postgresql.log :

-1 log: connection received: host = 172.XXX.XXX.XXX port = 61877
-1FATAL: GSSAPI authentication failed for 'userXX' user


userXX exists in our postgresql server and pg_hba.conf applied to
172.XXX.XXX.XXX subnet is:

hostall all 172.0.0.0/8 gss

Our postgresql.conf use keytab:
krb_server_keyfile = 'postgres.keytab'


And I have generated keytab with this ktpass command:

ktpass -out postgres.keytab -princ
postgres/hostname@domain -mapUser postgres -pass
XXX -crypto DES-CBC-MD5

The postgres user, exists in the Active Directory and it has a spn
defined:

C:\Users\Administratorsetspn -S postgres/hostname
 domain\postgres

Checking domain DC=domain
Registering ServicePrincipalNames for CN=postgres,CN=Users,DC=domain 
postgres/hostname

Updated object


If I login from a linux client to linux server, there is no problem:

[root@hostnane datos]# su - userXX
[userXX@hostname ~]$ klist
Ticket cache: FILE:/tmp/krb5cc_503
Default principal: userXX@domain
 
Valid starting ExpiresService principal
12/11/13 08:42:04  12/11/13 18:42:09  krbtgt/domain@domain
renew until 12/18/13 08:42:04
12/11/13 08:42:43  12/11/13 18:42:09  postgres/hostname@domain
renew until 12/18/13 08:42:04
[userXX@u2vbddpg ~]$ psql -h 172.XX.XX.XX
psql (9.2.1.3)
Type help for help.
 
edb=
 
 
Thanks 




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general