Thread: any alternative to pg-safeupdate for windows 10?
https://github.com/eradman/pg-safeupdate requires criteria for updates and deletes, so can protect from accidental wholesale updates / deletes.
but i have not been able to install it on my windows 10 machine.
i've installed python 3.7, pgxnclient, but pgxnclient install safeupate fails
does any one know other extensions with functionalities similar to pg-safeupdate that can be installed on a windows postgresql environment?
thanks in advance for any info
but i have not been able to install it on my windows 10 machine.
i've installed python 3.7, pgxnclient, but pgxnclient install safeupate fails
does any one know other extensions with functionalities similar to pg-safeupdate that can be installed on a windows postgresql environment?
thanks in advance for any info
does anyone know how to get past this?
pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir
i am the admin in the postgresql11 machine i'm trying to install the "safeupdate" extension to
and "C:\PostgreSQL11\bin" is in my PATH
pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir
i am the admin in the postgresql11 machine i'm trying to install the "safeupdate" extension to
and "C:\PostgreSQL11\bin" is in my PATH
On Thu, Sep 19, 2019 at 11:47 AM john snow <ofbizfanster@gmail.com> wrote:
https://github.com/eradman/pg-safeupdate requires criteria for updates and deletes, so can protect from accidental wholesale updates / deletes.
but i have not been able to install it on my windows 10 machine.
i've installed python 3.7, pgxnclient, but pgxnclient install safeupate fails
does any one know other extensions with functionalities similar to pg-safeupdate that can be installed on a windows postgresql environment?
thanks in advance for any info
does anyone know how to get past this?
pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir
i am the admin in the postgresql11 machine i'm trying to install the "safeupdate" extension to
and "C:\PostgreSQL11\bin" is in my PATH
pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir
i am the admin in the postgresql11 machine i'm trying to install the "safeupdate" extension to
and "C:\PostgreSQL11\bin" is in my PATH
On Thu, Sep 19, 2019 at 11:47 AM john snow <ofbizfanster@gmail.com> wrote:
https://github.com/eradman/pg-safeupdate requires criteria for updates and deletes, so can protect from accidental wholesale updates / deletes.
but i have not been able to install it on my windows 10 machine.
i've installed python 3.7, pgxnclient, but pgxnclient install safeupate fails
does any one know other extensions with functionalities similar to pg-safeupdate that can be installed on a windows postgresql environment?
thanks in advance for any info
On Thu, Sep 19, 2019 at 5:01 AM john snow <ofbizfanster@gmail.com> wrote:
does anyone know how to get past this?
pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir
i am the admin in the postgresql11 machine i'm trying to install the "safeupdate" extension to
and "C:\PostgreSQL11\bin" is in my PATHOn Thu, Sep 19, 2019 at 11:47 AM john snow <ofbizfanster@gmail.com> wrote:https://github.com/eradman/pg-safeupdate requires criteria for updates and deletes, so can protect from accidental wholesale updates / deletes.
but i have not been able to install it on my windows 10 machine.
i've installed python 3.7, pgxnclient, but pgxnclient install safeupate fails
does any one know other extensions with functionalities similar to pg-safeupdate that can be installed on a windows postgresql environment?
When you say you are an "in the postgresql11 machine" does that mean you are an admin in Postgres or you're an admin as a Windows user? If the former, obviously you should get Windows admin rights. If the latter, are you running your command prompt in elevated admin mode or just regular user mode? (You should be running the cmd prompt in elevated admin mode, I think).
Steve
On Thu, Sep 19, 2019 at 5:01 AM john snow <ofbizfanster@gmail.com> wrote:
does anyone know how to get past this?
pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir
i am the admin in the postgresql11 machine i'm trying to install the "safeupdate" extension to
and "C:\PostgreSQL11\bin" is in my PATHOn Thu, Sep 19, 2019 at 11:47 AM john snow <ofbizfanster@gmail.com> wrote:https://github.com/eradman/pg-safeupdate requires criteria for updates and deletes, so can protect from accidental wholesale updates / deletes.
but i have not been able to install it on my windows 10 machine.
i've installed python 3.7, pgxnclient, but pgxnclient install safeupate fails
does any one know other extensions with functionalities similar to pg-safeupdate that can be installed on a windows postgresql environment?
When you say you are an "in the postgresql11 machine" does that mean you are an admin in Postgres or you're an admin as a Windows user? If the former, obviously you should get Windows admin rights. If the latter, are you running your command prompt in elevated admin mode or just regular user mode? (You should be running the cmd prompt in elevated admin mode, I think).
Steve