Re: [GENERAL] Multi tenancy : schema vs databases

2016-10-02 Thread Achilleas Mantzios 

On 30/09/2016 18:45, Rakesh Kumar wrote:

I've been reading this discussion with great interest, to see what other
Postgres experts think. :-)

I am bit disappointed that most of the replies are questioning why we are
doing what we are doing. Once again, we (db designers) have no choice
in that.  What I would like to know that which one is better :- multiple db
vs multiple schema.  Read few interesting arguments and noted that
connection pooling works better with multiple schemas than dbs. Anything else?


Since you missed it, i write it once again :

same organization (e.g. holding) -> schemas
different organizations -> DBs



thanks




--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt



--
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] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Edson Richter 

On 02/10/2016 17:04, Devrim Gündüz wrote:
> Hi,
>
> On Sun, 2016-10-02 at 17:52 +, Edson Richter wrote:
>> I'm trying to install pgAdmin4 in Oracle EL 7.
>>
>> I've already installed PostgreSQL 9.6 final in same server (have EPEL
>> enabled, as well pgdg 9.6 repos).
>>
>> Running "yum install pgadmin4-web" I get the following result:
>> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>> Requires: python-blinker >= 1.3
> I've tested pgadmin4 RPMs on CentOS 7 so far, it seems even though Fedoragit
> says something different, blinker does not seem to appear in the RHEL andOEL
> repos.
>
> So, just added blinker to PGDG repo, under testing. If you have the latest
> repository file, you can test this package with:
>
> yum --enablerepo pgdg96-updates-testing install pgadmin4-web
>
> (the package will appear in next hour)

It is not working, I get the following error:

[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web
Loaded plugins: ulninfo
epel/x86_64/metalink | 2.6 kB  00:00:00
ol7_UEKR3 | 1.2 kB  00:00:00
ol7_latest | 1.4 kB  00:00:00
pgdg96 | 4.1 kB  00:00:00
https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server-x86_64/repodata/repomd.xml:
 
[Errno 14] HTTPS Error 404 - Not Found
Trying other mirror.


  One of the configured repositories failed (PostgreSQL 9.6 7Server - 
x86_64),
  and yum doesn't have enough cached data to continue. At this point the 
only
  safe thing yum can do is fail. There are a few ways to work "fix" this:

  1. Contact the upstream for the repository and get them to fix the 
problem.

  2. Reconfigure the baseurl/etc. for the repository, to point to a 
working
 upstream. This is most often useful if you are using a newer
 distribution release than is supported by the repository (and the
 packages for the previous distribution release still work).

  3. Disable the repository, so yum won't use it by default. Yum 
will then
 just ignore the repository until you permanently enable it 
again or use
 --enablerepo for temporary usage:

 yum-config-manager --disable pgdg96-updates-testing

  4. Configure the failing repository to be skipped, if it is 
unavailable.
 Note that yum will try to contact the repo. when it runs most 
commands,
 so will have to try and fail each time (and thus. yum will be 
be much
 slower). If it is a very temporary problem though, this is 
often a nice
 compromise:

 yum-config-manager --save 
--setopt=pgdg96-updates-testing.skip_if_unavailable=true

failure: repodata/repomd.xml from pgdg96-updates-testing: [Errno 256] No 
more mirrors to try.
https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server-x86_64/repodata/repomd.xml:
 
[Errno 14] HTTPS Error 404 - Not Found


>
>> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> (pgdg96)   Requires: libpython2.7_d.so.1.0()(64bit)
>>   You could try using --skip-broken to work around the problem
>>   You could try running: rpm -Va --nofiles --nodigest"
> This is also something that I need to test, but it is too late in here now,
> will look tomorrow.

I have several machines with OEL 7, I'll be delighted to help debug. I 
can even provide root access to a virtual machine with OEL 7 for if you 
need one.

Regards,

Edson Richter


>
> Regards,
> --
> Devrim GÜNDÜZ
> EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR


-- 
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] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Edson Richter 

On 02/10/2016 16:05, Adrian Klaver wrote:
> On 10/02/2016 10:52 AM, Edson Richter wrote:
>> Dear community,
>>
>>
>> I'm trying to install pgAdmin4 in Oracle EL 7.
>>
>> I've already installed PostgreSQL 9.6 final in same server (have EPEL
>> enabled, as well pgdg 9.6 repos).
>>
>> Running "yum install pgadmin4-web" I get the following result:
>>
>>
>> "[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web
>>
>> Loaded plugins: ulninfo
>> Resolving Dependencies
>> --> Running transaction check
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-psycopg2-debug >= 2.6.2 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-passlib >= 1.6.2 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-html5lib >= 1.0b3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-crypto >= 2.6.1 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Processing Dependency: python-click for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> --> Running transaction check
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> ---> Package python-click.noarch 0:6.3-1.el7 will be installed
>> ---> Package python-html5lib.noarch 1:0.999-5.el7 will be installed
>> ---> Package python-passlib.noarch 0:1.6.2-2.el7 will be installed
>> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be
>> installed
>> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
>> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> ---> Package python2-crypto.x86_64 0:2.6.1-9.el7 will be installed
>> --> Processing Dependency: libtomcrypt.so.0()(64bit) for package:
>> python2-crypto-2.6.1-9.el7.x86_64
>> --> Running transaction check
>> ---> Package libtomcrypt.x86_64 0:1.17-23.el7 will be installed
>> --> Processing Dependency: libtommath >= 0.42.0 for package:
>> libtomcrypt-1.17-23.el7.x86_64
>> --> Processing Dependency: libtommath.so.0()(64bit) for package:
>> libtomcrypt-1.17-23.el7.x86_64
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be
>> installed
>> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
>> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> --> Running transaction check
>> ---> Package libtommath.x86_64 0:0.42.0-4.el7 will be installed
>> ---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
>> --> Processing Dependency: python-blinker >= 1.3 for package:
>> pgadmin4-web-1.0-1.rhel7.noarch
>> ---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be
>> installed
>> --> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
>> python-psycopg2-debug-2.6.2-2.rhel7.x86_64
>> --> Finished Dependency Resolution
>> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>>Requires: python-blinker >= 1.3
>> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64 (pgdg96)
>>Requires: libpython2.7_d.so.1.0()(64bit)
>>  You could try using --skip-broken to work around the problem
>>  You could try running: rpm -Va --nofiles --nodigest"
>>
>> (the "LANG=C" at beginning of the line is to force output in english,
>> please ignore it)
>>
>> Have anyone faced similar issue or know how to correct this error?
>
> First what version of Python is your system default?

python.x86_64 2.7.5-39.0.1.el7_2 @ol7_latest


>
> Second there seems to be some unfilled dependencies:
>
> python-blinker >= 1.3

[root@backup1 yum.repos.d]# yum search python-blinker
Plugins carregados: ulninfo
=== Encontrado: python-blinker 

python-flask-principal.noarch : Identity management for Flask applications


>
> libpython2.7_d.so.1.0()(64bit)
>
> At a guess you can try to YUM install python-blinker for the first.
>

Not sure if I did it right, but python-flask-principal.noarch is already 
installed - would be a dependency problem? The package is not where it 
is supposed to be?

>
> For the second I am thinking you need something along the lines of
> python-devel installed.
>

That was my first thought:

[root@backup1 yum.repos.d]# LANG=C yum install python-devel
Loaded plugins: ulninfo
Package python-devel-2.7.5-39.0.1.el7_2.x86_64 already installed and 
latest version
Nothing to do


So it is already installed.

Regards,

Edson Richter


>
>>
>> Thanks in advance,
>>
>> Edson Richter
>>
>
>



-- 
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] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Devrim Gündüz 

Hi,

On Sun, 2016-10-02 at 17:52 +, Edson Richter wrote:
> I'm trying to install pgAdmin4 in Oracle EL 7.
> 
> I've already installed PostgreSQL 9.6 final in same server (have EPEL
> enabled, as well pgdg 9.6 repos).
> 
> Running "yum install pgadmin4-web" I get the following result:
> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>    Requires: python-blinker >= 1.3

I've tested pgadmin4 RPMs on CentOS 7 so far, it seems even though Fedora git
says something different, blinker does not seem to appear in the RHEL and OEL
repos.

So, just added blinker to PGDG repo, under testing. If you have the latest
repository file, you can test this package with:

yum --enablerepo pgdg96-updates-testing install pgadmin4-web 

(the package will appear in next hour)

> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64
> (pgdg96)   Requires: libpython2.7_d.so.1.0()(64bit)
>  You could try using --skip-broken to work around the problem
>  You could try running: rpm -Va --nofiles --nodigest"

This is also something that I need to test, but it is too late in here now,
will look tomorrow.

Regards,
-- 
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Adrian Klaver 

On 10/02/2016 10:52 AM, Edson Richter wrote:

Dear community,


I'm trying to install pgAdmin4 in Oracle EL 7.

I've already installed PostgreSQL 9.6 final in same server (have EPEL
enabled, as well pgdg 9.6 repos).

Running "yum install pgadmin4-web" I get the following result:


"[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web

Loaded plugins: ulninfo
Resolving Dependencies
--> Running transaction check
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-psycopg2-debug >= 2.6.2 for package:
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-passlib >= 1.6.2 for package:
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-html5lib >= 1.0b3 for package:
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-crypto >= 2.6.1 for package:
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-blinker >= 1.3 for package:
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-click for package:
pgadmin4-web-1.0-1.rhel7.noarch
--> Running transaction check
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-blinker >= 1.3 for package:
pgadmin4-web-1.0-1.rhel7.noarch
---> Package python-click.noarch 0:6.3-1.el7 will be installed
---> Package python-html5lib.noarch 1:0.999-5.el7 will be installed
---> Package python-passlib.noarch 0:1.6.2-2.el7 will be installed
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
---> Package python2-crypto.x86_64 0:2.6.1-9.el7 will be installed
--> Processing Dependency: libtomcrypt.so.0()(64bit) for package:
python2-crypto-2.6.1-9.el7.x86_64
--> Running transaction check
---> Package libtomcrypt.x86_64 0:1.17-23.el7 will be installed
--> Processing Dependency: libtommath >= 0.42.0 for package:
libtomcrypt-1.17-23.el7.x86_64
--> Processing Dependency: libtommath.so.0()(64bit) for package:
libtomcrypt-1.17-23.el7.x86_64
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-blinker >= 1.3 for package:
pgadmin4-web-1.0-1.rhel7.noarch
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
--> Running transaction check
---> Package libtommath.x86_64 0:0.42.0-4.el7 will be installed
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-blinker >= 1.3 for package:
pgadmin4-web-1.0-1.rhel7.noarch
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package:
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
   Requires: python-blinker >= 1.3
Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64 (pgdg96)
   Requires: libpython2.7_d.so.1.0()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest"

(the "LANG=C" at beginning of the line is to force output in english,
please ignore it)

Have anyone faced similar issue or know how to correct this error?


First what version of Python is your system default?

Second there seems to be some unfilled dependencies:

python-blinker >= 1.3

libpython2.7_d.so.1.0()(64bit)

At a guess you can try to YUM install python-blinker for the first.


For the second I am thinking you need something along the lines of 
python-devel installed.





Thanks in advance,

Edson Richter




--
Adrian Klaver
adrian.kla...@aklaver.com


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

[GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Edson Richter 
Dear community,


I'm trying to install pgAdmin4 in Oracle EL 7.

I've already installed PostgreSQL 9.6 final in same server (have EPEL enabled, 
as well pgdg 9.6 repos).

Running "yum install pgadmin4-web" I get the following result:


"[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web

Loaded plugins: ulninfo
Resolving Dependencies
--> Running transaction check
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-psycopg2-debug >= 2.6.2 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-passlib >= 1.6.2 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-html5lib >= 1.0b3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-crypto >= 2.6.1 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-blinker >= 1.3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Processing Dependency: python-click for package: 
pgadmin4-web-1.0-1.rhel7.noarch
--> Running transaction check
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-blinker >= 1.3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
---> Package python-click.noarch 0:6.3-1.el7 will be installed
---> Package python-html5lib.noarch 1:0.999-5.el7 will be installed
---> Package python-passlib.noarch 0:1.6.2-2.el7 will be installed
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package: 
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
---> Package python2-crypto.x86_64 0:2.6.1-9.el7 will be installed
--> Processing Dependency: libtomcrypt.so.0()(64bit) for package: 
python2-crypto-2.6.1-9.el7.x86_64
--> Running transaction check
---> Package libtomcrypt.x86_64 0:1.17-23.el7 will be installed
--> Processing Dependency: libtommath >= 0.42.0 for package: 
libtomcrypt-1.17-23.el7.x86_64
--> Processing Dependency: libtommath.so.0()(64bit) for package: 
libtomcrypt-1.17-23.el7.x86_64
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-blinker >= 1.3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package: 
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
--> Running transaction check
---> Package libtommath.x86_64 0:0.42.0-4.el7 will be installed
---> Package pgadmin4-web.noarch 0:1.0-1.rhel7 will be installed
--> Processing Dependency: python-blinker >= 1.3 for package: 
pgadmin4-web-1.0-1.rhel7.noarch
---> Package python-psycopg2-debug.x86_64 0:2.6.2-2.rhel7 will be installed
--> Processing Dependency: libpython2.7_d.so.1.0()(64bit) for package: 
python-psycopg2-debug-2.6.2-2.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
   Requires: python-blinker >= 1.3
Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.x86_64 (pgdg96)
   Requires: libpython2.7_d.so.1.0()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest"

(the "LANG=C" at beginning of the line is to force output in english, please 
ignore it)

Have anyone faced similar issue or know how to correct this error?

Thanks in advance,

Edson Richter

Re: [GENERAL] Query generator

2016-10-02 Thread Julien Rouhaud 
On 29/09/2016 23:23, Vinicius Segalin wrote:
> 2016-09-29 16:32 GMT-03:00 Julien Rouhaud  >:
> You should try sqlsmith (https://github.com/anse1/sqlsmith
> ), which works
> very well.
> 
> 
> I had found this one before, but all I could get was queries using
> "standard" tables, like the ones from pg_catalog and information_schema.
> It didn't generate queries from the tables I've created. Was I doing
> something wrong?
> 

I don't think so, unless you specified an empty database with the
--target option. I never had this issue myself, so I can only advice you
to open an issue on the project repository if you still have this problem.

-- 
Julien Rouhaud
http://dalibo.com - http://dalibo.org


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