Re: Help with plpython3u

On 6/10/20 4:35 PM, PEDRO PABLO SEVERIN HONORATO wrote: something like EDB_PYTHONHOME that only the Postgres install would use. That's exactly what I was looking for. Isn't a way to configure some postgres file, so that postgres would use that file and look for python in that directory before

Re: Help with plpython3u

something like EDB_PYTHONHOME that only the Postgres install would use. That's exactly what I was looking for. Isn't a way to configure some postgres file, so that postgres would use that file and look for python in that directory before seeing the path? I guess you have to ask questions on Stack

Re: Help with plpython3u

On 6/10/20 10:39 AM, PEDRO PABLO SEVERIN HONORATO wrote: I'm sorry, when I try to create a plpython3u function, the database tells me: "*ERROR: could not load library "C:/Program Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not be found. SQL state: 58P01*" If I try to exe

Re: Help with plpython3u

I just think it would make your life easier to reduce the number of Python installs you have. If I'm keeping track correctly you now have: 1) Anaconda Python 2) OS system Python 3) EDB Python. The OS is windows, and afaik python is not included in windows, so it would be just Anaconda python an

Re: Help with plpython3u

On 6/10/20 10:39 AM, PEDRO PABLO SEVERIN HONORATO wrote: I'm sorry, when I try to create a plpython3u function, the database tells me: "*ERROR: could not load library "C:/Program Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not be found. SQL state: 58P01*" If I try to exe

Re: Help with plpython3u

I'm sorry, when I try to create a plpython3u function, the database tells me: " *ERROR: could not load library "C:/ProgramFiles/PostgreSQL/12/lib/plpython3.dll": The specified module could notbe found. SQL state: 58P01*" If I try to execute the function, then the database crashes. El mié., 10 j

Re: Help with plpython3u

On 6/10/20 9:57 AM, PEDRO PABLO SEVERIN HONORATO wrote: Alright. Before we go any further it would be best to determine what your needs are. So: 1) Did you install Anaconda just to get Python or for the science data set of libraries it provides? A: For the data science set of libraries. Also, i

RE: Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory

Hi Michael, We have table having rows 2.5 millions records inserted and updated in each hour and another table having about 1 million records in an hour. WE have dedicated column added in table that have list of 1-500 and this column is used as partition key. Idea behind the 500 partition is to

Re: Help with plpython3u

Alright. Before we go any further it would be best to determine what your needs are. So: 1) Did you install Anaconda just to get Python or for the science data set of libraries it provides? A: For the data science set of libraries. Also, it helps to keep libraries updated. 2) Do you need the sys

Re: Postgres server 12.2 crash with process exited abnormally and possibly corrupted shared memory

On Wed, Jun 10, 2020 at 12:05 AM Ishan Joshi wrote: > How many rows did these tables have before partitioning? à We starts > test with 0 rows in partition table. > Partitions are far from free and pruning is great but not guaranteed. How many total rows do you currently have or foresee hav

Re: Parallel safety of contrib extensions

"Winfield, Steven" writes: > There was a thread about this back in 2016[1], but I've just been bitten by > it and wondered if any (more) extensions, particularly btree_gist, will have > their operators/functions verified and marked as parallel-safe? Whenever somebody does the legwork and sends

Re: [HELP] Reset postgres server

On 6/10/20 9:31 AM, Praveen Kumar K S wrote: Hello, Yes, both are part of dev. Should I clean the data directory on both servers or only on master ? Both otherwise the standby will be working with out of date data and will not sync. On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver

Re: [HELP] Reset postgres server

Hello, Yes, both are part of dev. Should I clean the data directory on both servers or only on master ? On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver wrote: > On 6/10/20 5:33 AM, Praveen Kumar K S wrote: > > Hello, > > > > I have a master and slave setup running and sometimes we have to do a >

Re: Help with plpython3u

On 6/10/20 8:25 AM, PEDRO PABLO SEVERIN HONORATO wrote: Just to be clear those where instructions from here, correct?: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html# Yes. When I did that I could

Re: Help with plpython3u

Just to be clear those where instructions from here, correct?: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html# Yes. When I did that I could execute python functions and create the extension in post

Parallel safety of contrib extensions

Hi all, There was a thread about this back in 2016[1], but I've just been bitten by it and wondered if any (more) extensions, particularly btree_gist, will have their operators/functions verified and marked as parallel-safe? In our case, we're interested in the float8 <-> float8 operator. Altho

Re: Help with plpython3u

On 6/10/20 7:39 AM, PEDRO PABLO SEVERIN HONORATO wrote: Thank you Adrian, will see the link you sent me. Thank you, Laurenz. I noticed that copying the DLL is not a good idea. How can I set a python path for postgres, so that I tell postgres "hey, if you are looking for python see this path" an

Re: Help with plpython3u

Thank you Adrian, will see the link you sent me. Thank you, Laurenz. I noticed that copying the DLL is not a good idea. How can I set a python path for postgres, so that I tell postgres "hey, if you are looking for python see this path" and don't lose conda? Because after following all Adrian's in

Re: [HELP] Reset postgres server

On 6/10/20 5:33 AM, Praveen Kumar K S wrote: Hello, I have a master and slave setup running and sometimes we have to do a complete refresh on dev environments. How can I reset postgres server so that it wipes out everything including WAL ? So that I configure master/slave streaming replicatio

Re: Help with plpython3u

On 6/9/20 10:38 PM, PEDRO PABLO SEVERIN HONORATO wrote: Thank you, Adrian. Will read about all this. By the way, the issue reappeared. For some reason, I had to reinstall Anaconda and had to delete the "PYTHONHOME" variable because I could not launch conda. Seems that they both fight for the sa

Re: javascript app running in crhome with connection to postgreSQL

Hi Stan. I have been dealing with this lately. I have a Chrome Extension that does work gathering the info to save in the postgresql, such as screen scraping a specific tab. I am using AWS RDS hosted Postgresql, btw. I am not sure however, due to security reasons, that you can open a connection *d

javascript app running in crhome with connection to postgreSQL

OK, I have to admit this is a case of my being influenced by things going on in the news, which I am not normally influenced by. All the news about the touch screens on the crew dragon capsule using a JavaScript app running in Chrome, have me thinking about doing some testing for a project I am

Re: [HELP] Reset postgres server

Providing more details. OS is Ubuntu 16.04 and postgres is installed from APT. logical and physical replication slots configured on master. No WAL archiving configured. Streaming replication is enabled on master. Slave is hot-standby On Wed, Jun 10, 2020 at 6:03 PM Praveen Kumar K S wrote: > Hel

[HELP] Reset postgres server

Hello, I have a master and slave setup running and sometimes we have to do a complete refresh on dev environments. How can I reset postgres server so that it wipes out everything including WAL ? So that I configure master/slave streaming replication again from scratch ? TIA. -- *Regards,* *K

Re: Something else about Redo Logs disappearing

Greetings, * Peter (p...@citylink.dinoex.sub.org) wrote: > On Tue, Jun 09, 2020 at 03:42:48PM -0400, Stephen Frost wrote: > ! > And then 90% of the things offered here become superfluous, because > ! > they are already handled site-wide. And then you will have to > ! > consider integration of both

Re: Something else about Redo Logs disappearing

On Tue, Jun 09, 2020 at 03:42:48PM -0400, Stephen Frost wrote: ! > And then 90% of the things offered here become superfluous, because ! > they are already handled site-wide. And then you will have to ! > consider integration of both pieces - and that will most likely be ! > more work and more erro

Re: Something else about Redo Logs disappearing

On Wed, Jun 10, 2020 at 1:53 AM Peter wrote: > On Tue, Jun 09, 2020 at 12:34:38PM -0700, Adrian Klaver wrote: > > ! The backup solution is? > > https://www.bareos.com/ > > ! Fine rant below. Go forth and work your wonders. > > I don't need to, anymore. I did that, for about 20 years - people > I

Re: Multitenent architecture

On 4/6/20 6:52 μ.μ., Vasu Madhineni wrote: Hi All, We are planning a POC on multitenant architecture in Postgres, Could you please help us with steps for multitenant using schema for each application model. Hello, you may benefit from this blog post : https://severalnines.com/database-blog/mul