Re: [GENERAL] Request to share information regarding postgresql pg_xlog file.

2016-09-14 Thread John R Pierce
On 9/14/2016 10:09 PM, Yogesh Sharma wrote: Thanks for your support and suggestion. We are using below postgresql rpm. postgresql-8.1.18-2.1 thats not the full RPM name, thats just the version. 8.1 has been obsolete and unsupported for about 6 years now. 8.1.18 was released in 2009, the f

[GENERAL] Request to share information regarding postgresql pg_xlog file.

2016-09-14 Thread Yogesh Sharma
Dear Team, Thanks for your support and suggestion. We are using below postgresql rpm. postgresql-8.1.18-2.1 In our system, below error is found and occurring is very frequent. CONTEXT: writing block 53 of relation 1663/16385/280951 ERROR: could not open relation 1663/16385/280951: No such file

Re: [GENERAL] Restricted access on DataBases

2016-09-14 Thread Charles Clavadetscher
Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Durumdara Sent: Mittwoch, 14. September 2016 17:13 Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restricted access on DataBases Dear Adrian and Charles! I tried to create a

[GENERAL] ANN: Upscene releases Database Workbench 5.2.2

2016-09-14 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: Database Workbench 5.2.2 " This release includes support for PostgreSQL and adds several other features and bugfixes. http://www.upscene.com/news/item/20160914 Dat

Re: [GENERAL] Restricted access on DataBases

2016-09-14 Thread Durumdara
Dear Adrian and Charles! I tried to create a step by step instruction. The real commands are separated by ";" Other commands are: "login as username", "use db" I ran them in PGAdmin with changing the connection to simulate what I feel as problem. I suppused the ex_dbuser have owner rights to the

Re: [GENERAL] Restricted access on DataBases

2016-09-14 Thread Adrian Klaver
On 09/14/2016 06:52 AM, Durumdara wrote: Dear Charles! I thought before this test that mainuser get all rights as dbuser, so it have rights to the next (future) objects too. So mainuser and dbuser have equivalent rights in db database. Thanks for your every info! In my previous post I men

Re: [GENERAL] Dynamic query return

2016-09-14 Thread David G. Johnston
On Wed, Sep 14, 2016 at 2:00 AM, Mat Arye wrote: > I am leaning towards solution 3 for now. But it's kind of a hack. Is there > any better solution that I am missing? > ​You probably will want to look into using/returning a cursor - though I'm not that familiar with them myself. David J. ​

Re: [GENERAL] Predicting query runtime

2016-09-14 Thread Vinicius Segalin
2016-09-14 7:23 GMT-03:00 Oleg Ivanov : > > > I hope listed papers will be useful for your master's thesis. > > I'm sure they will! Thank you, Oleg.

Re: [GENERAL] Restricted access on DataBases

2016-09-14 Thread Adrian Klaver
On 09/14/2016 06:52 AM, Durumdara wrote: Dear Charles! I checked your solution. For example: db - database dbuser, mainuser 1. dbuser own the database, and the objects in it. 2. mainuser member of dbuser. 3. public connection revoked. Ok. Then dbuser can see all tables, and mainuser too. Ok.

Re: [GENERAL] Restricted access on DataBases

2016-09-14 Thread Durumdara
Dear Charles! I checked your solution. For example: db - database dbuser, mainuser 1. dbuser own the database, and the objects in it. 2. mainuser member of dbuser. 3. public connection revoked. Ok. Then dbuser can see all tables, and mainuser too. Ok. The operation (overlord): 1. set role to

Re: [GENERAL] Predicting query runtime

2016-09-14 Thread Oleg Ivanov
Hi Vinicius, I recommend you to read this (http://www.doc.ic.ac.uk/~nb605/IO%20performance%20modeling%20research/Learning-based%20Query%20Performance%20-%202011.pdf) paper. Authors make a nice classification of different query performance prediction methods and propose their own solution for t

[GENERAL] pgAdmin3 backup over ssh tunnel

2016-09-14 Thread Alex Sviridov
Hi all I have the same problem is it is described here http://stackoverflow.com/questions/32398311/pgadmin3-backup-over-ssh-tunnel I use pgadmin 1.22.1 and when I try to make backup it instead of working with database over ssh tunel works with localhost database. How to fix it? It this bug fir

[GENERAL] Dynamic query return

2016-09-14 Thread Mat Arye
Hi All, I have a project where I wrote custom plpgsql functions to do specialized queries of my dataset. These functions dynamically generate sql and then RETURN EXECUTE that generated sql. From the client perspective the usage looks like: SELECT * FROM exec_query(new_query_object(param1 => 'blah

Re: [GENERAL] Installing 9.6 RC on Ubuntu

2016-09-14 Thread Raymond O'Donnell
On 13/09/16 19:03, Steve Crawford wrote: I'm trying to install 9.6 RC1 on Ubuntu 16.04 Xenial on my laptop and it seems broken. Installation of 9.6 RC1 on Centos was straightforward by comparison - just add the 9.6 yum package and install. Unfortunately Ubuntu seems second-class by comparison.