On Thu, Nov 9, 2017 at 8:07 AM, Günce Kaya <guncekaya14@gmail.com> wrote:Hi again,I have created rep user like;CREATE USER rep REPLICATION LOGIN ENCRYPTED PASSWORD 'xxxx';So, user having replication permission. Maybe I miss something about this situation. Is there anything additional for that?For more details please go through the below link provided.https://www.postgresql.org/docs/current/static/app-pgbasebackup.html Regards,GunceOn Thu, Nov 9, 2017 at 8:49 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:On Thu, Nov 9, 2017 at 6:27 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14@gmail.com> wrote:Hello,I'm getting error when using pg_basebackup as bellow;pg_basebackup: could not create directory "/data": Permission deniedI couldn't overcome with that problem. Any suggestion would be appreciated.Regards,Gunce KayaLinkedin - Twitter - BlogHi Gunce Kaya,/data -- directory requires postgres user permission. In addition to this, the user might not be a valid DB user having enough privileges in order to perform backup having entry in pg_hba file.-- Gunce KayaLinkedin - Twitter - Blog --
Hi again,I have created rep user like;CREATE USER rep REPLICATION LOGIN ENCRYPTED PASSWORD 'xxxx';So, user having replication permission. Maybe I miss something about this situation. Is there anything additional for that?
Regards,GunceOn Thu, Nov 9, 2017 at 8:49 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:On Thu, Nov 9, 2017 at 6:27 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14@gmail.com> wrote:Hello,I'm getting error when using pg_basebackup as bellow;pg_basebackup: could not create directory "/data": Permission deniedI couldn't overcome with that problem. Any suggestion would be appreciated.Regards,Gunce KayaLinkedin - Twitter - BlogHi Gunce Kaya,/data -- directory requires postgres user permission. In addition to this, the user might not be a valid DB user having enough privileges in order to perform backup having entry in pg_hba file.-- Gunce KayaLinkedin - Twitter - Blog
On Thu, Nov 9, 2017 at 6:27 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14@gmail.com> wrote:Hello,I'm getting error when using pg_basebackup as bellow;pg_basebackup: could not create directory "/data": Permission deniedI couldn't overcome with that problem. Any suggestion would be appreciated.Regards,Gunce KayaLinkedin - Twitter - BlogHi Gunce Kaya,/data -- directory requires postgres user permission. In addition to this, the user might not be a valid DB user having enough privileges in order to perform backup having entry in pg_hba file.
On Thu, Nov 9, 2017 at 6:16 AM, Günce Kaya <guncekaya14@gmail.com> wrote:Hello,I'm getting error when using pg_basebackup as bellow;pg_basebackup: could not create directory "/data": Permission deniedI couldn't overcome with that problem. Any suggestion would be appreciated.Regards,Gunce KayaLinkedin - Twitter - BlogHi Gunce Kaya,/data -- directory requires postgres user permission.
Hello,I'm getting error when using pg_basebackup as bellow;pg_basebackup: could not create directory "/data": Permission deniedI couldn't overcome with that problem. Any suggestion would be appreciated.Regards,Gunce KayaLinkedin - Twitter - Blog
Hi Gunce Kaya,
/data -- directory requires postgres user permission.
In addition to this, the user might not be a valid DB user having enough privileges in order to perform backup having entry in pg_hba file.
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных