Re: [GENERAL] pg_basebackup issue

On 04/22/2017 08:04 PM, chiru r wrote: Use case: Want to control database privileges/default roles by creating roles instead of granting directly to users. So that we can manage database access control easily. Which you can do. However, pg_basebackup is a cluster wide command not tied a

Re: [GENERAL] pg_basebackup issue

Use case: Want to control database privileges/default roles by creating roles instead of granting directly to users. So that we can manage database access control easily. Thanks, Chiru On Sat, Apr 22, 2017 at 10:03 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Saturday, April

Re: [GENERAL] pg_basebackup issue

On Saturday, April 22, 2017, chiru r wrote: > Thank you Adrian. > > It seems the code is allowing only who has Superuser/Replication role > directly. > > Is there any possibility in future releases they allow both case A & B > Users able to use pg_basebackup. > > It does not

Re: [GENERAL] pg_basebackup issue

Thank you Adrian. It seems the code is allowing only who has Superuser/Replication role directly. Is there any possibility in future releases they allow both case A & B Users able to use pg_basebackup. Working: A) CREATE USER backup_user SUPERUSER; Not working: B) postgres=# create user

Re: [GENERAL] pg_basebackup issue

On 04/22/2017 12:56 PM, chiru r wrote: Thanks you. The FATAL message is not clear. Yes, It is helpful if someone with more knowledge of the connection code. Well if your interested in looking for yourself look here: src/backend/utils/init/postinit.c

Re: [GENERAL] pg_basebackup issue

Thanks you. The FATAL message is not clear. Yes, It is helpful if someone with more knowledge of the connection code. [postgres@pgserver ~]$ /opt/PostgreSQL/9.5/bin/pg_basebackup --format=t --pgdata=online_backups1 -p 5432 -U *backup_admin* -x -z --verbose *pg_basebackup: could not connect to

Re: [GENERAL] Total ram size study

On 4/22/2017 8:27 AM, Melvin Davidson wrote: *Has anyone ever done a study on performance increase via ram increase? I have a client on AWS with 8GB total ram (2GB shared_buffers), and I am curious if doubling the ram to 16GB (4GB shared_buffers) will result in minimizing query response time.*

Re: [GENERAL] Not sure this should be asked here but...

On Sat, Apr 22, 2017 at 12:04 PM, Ron Ben wrote: > Why to use mailining list rather than forum? > forum gives much more flexablitiy, easy to read and respond, allows to > search for other simillar issues, topics can be tagged... > > > ​Was this intended to display irony re:

[GENERAL] Not sure this should be asked here but...

Why to use mailining list rather than forum? forum gives much more flexablitiy, easy to read and respond, allows to search for other simillar issues, topics can be tagged...    

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

On 04/21/2017 05:14 PM, Periko Support wrote: Hi guys. I would to explain my current strange issue with our label printer -. Windows 8.1 x64, psqlodbc 9.5x86/x64 drivers tested. The issue is that every time we print labels that read data from the DB, the print start printing with pause on

Re: [GENERAL] pg_basebackup issue

On 04/22/2017 10:04 AM, chiru r wrote: Thanks for the reply, Actually I am not setting Role for database specific,I did set Role to user. Since users and roles are global for all databases in PostgreSQL,I believe it should work for replication pesudo database. Except for the part where the

[GENERAL] Memory consumption for Query

How to check how much memory query is consuming. Is there tool can check of query consuming memory for the execution or output. Let's say for following query how to calculate memory consumption. select * from test where id=1; Sent from Outlook

Re: [GENERAL] pg_basebackup issue

Thanks for the reply, Actually I am not setting Role for database specific,I did set Role to user. Since users and roles are global for all databases in PostgreSQL,I believe it should work for replication pesudo database. Thanks, Chiru On Sat, Apr 22, 2017 at 12:34 PM, Adrian Klaver

Re: [GENERAL] Total ram size study

Is it possible so you can share your postgresql.conf file and system settings if any for this 256G ram installation pls? Thx Marcin Sent from my BlackBerry 10 smartphone. From: Melvin Davidson Sent: Saturday, April 22, 2017 18:31 To: Vick Khera Reply To: Melvin Davidson Cc:

Re: [GENERAL] pg_basebackup issue

On 04/22/2017 08:13 AM, chiru r wrote: But, SUPERUSER privileges are working, you can see above I am able to do CREATEUSER and CREATEDB. What is the differences in case A and case B for Superuser? I had flash of insight while driving. The insight being that the problem is down to this:

Re: [GENERAL] Total ram size study

Thanks Vick, Those were my thoughts as well. Your response gives me something to help convince the client to kick up the hardware. On Sat, Apr 22, 2017 at 12:20 PM, Vick Khera wrote: > I've not done a formal study, but I've always found that throwing hardware > at the problem

Re: [GENERAL] Total ram size study

I've not done a formal study, but I've always found that throwing hardware at the problem does wonders. My current database I made faster by bumping RAM until the entire working set fits in memory. The server has 256GB of RAM, half of which is used by ZFS for its purposes, and the other half for

[GENERAL] Total ram size study

*Has anyone ever done a study on performance increase via ram increase?I have a client on AWS with 8GB total ram (2GB shared_buffers), and I amcurious if doubling the ram to 16GB (4GB shared_buffers) will result in minimizing query response time.* -- *Melvin Davidson* I reserve the right to

Re: [GENERAL] pg_basebackup issue

But, SUPERUSER privileges are working, you can see above I am able to do CREATEUSER and CREATEDB. What is the differences in case A and case B for Superuser? Thanks, Chiru On Sat, Apr 22, 2017 at 10:45 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Saturday, April 22, 2017,

Re: [GENERAL] pg_basebackup issue

On Saturday, April 22, 2017, chiru r wrote: > Thank you for the reply. > > It is inheriting role attributes. I am able to do CREATEDB,CREATEROLE... > etc . > Even i am able to do manual start backup and stop backup also using > *backup_admin.* > So I've recently read that

Re: [GENERAL] pg_basebackup issue

Thank you for the reply. It is inheriting role attributes. I am able to do CREATEDB,CREATEROLE... etc . Even i am able to do manual start backup and stop backup also using *backup_admin.* But I am not able to do *pg_basebackup *using *backup_admin ** .* postgres=# create user backup_admin

Re: [GENERAL] pg_basebackup issue

On 04/22/2017 02:38 AM, John R Pierce wrote: On 4/22/2017 2:28 AM, chiru r wrote: I am using Postgresql 9.5 and I have created*backup_admin* user and created *dba_admin *ROLE with SUPERUSER and REPLICATION ,after that GRANT *dba_admin * role to backup_admin user and executed pg_basebakup

Re: [GENERAL] Recover PostgreSQL database folder data

On 22-04-2017 06:40, Magnus Hagander wrote: On Sat, Apr 22, 2017 at 3:05 AM, Cat > wrote: On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote: > Ls -la /var/lib/pgsql/9.6/data > > drwx--. 20 postgres postgres 4096 Abr

Re: [GENERAL] Recover PostgreSQL database folder data

On Sat, Apr 22, 2017 at 3:05 AM, Cat wrote: > On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote: > > Ls -la /var/lib/pgsql/9.6/data > > > > drwx--. 20 postgres postgres 4096 Abr 21 17:52 . > > drwx--. 4 root root51 Abr 21 06:33 .. > > Ensure

Re: [GENERAL] pg_basebackup issue

On 4/22/2017 2:28 AM, chiru r wrote: I am using Postgresql 9.5 and I have created*backup_admin* user and created *dba_admin *ROLE with SUPERUSER and REPLICATION ,after that GRANT *dba_admin * role to backup_admin user and executed pg_basebakup utility with backup_admin user. role group

[GENERAL] pg_basebackup issue

Hello, I am using Postgresql 9.5 and I have created* backup_admin* user and created *dba_admin *ROLE with SUPERUSER and REPLICATION ,after that GRANT *dba_admin * role to backup_admin user and executed pg_basebakup utility with backup_admin user. But I am not able to use the pg_basebackup