May be this would be the cause of you issue:
http://www.postgresql.org/docs/9.2/static/plpython-python23.html
It is not allowed to use PL/Python based on Python 2 and PL/Python based
on Python 3 in the same session, because the symbols in the dynamic
modules would clash, which could result in crashes of the PostgreSQL
server process. There is a check that prevents mixing Python major
versions in a session, which will abort the session if a mismatch is
detected. It is possible, however, to use both PL/Python variants in the
same database, from separate sessions.
On 31.03.2016 12:53, margrit drescher wrote:
I originally used the 9.4.6 version on
http://www.enterprisedb.com/products-services-training/pgdownload#windows
for 64-bit windows and loaded the language pack recommended in the
readme file.
On 31 March 2016 at 11:25, Alex Ignatov-2 [via PostgreSQL] <[hidden
email] </user/SendEmail.jtp?type=node&node=5896177&i=0>> wrote:
On 31.03.2016 10:50, margrit drescher wrote:
> I installed postgres 9.4.6 on my Windows 7 (64-bit) machine, and
managed to
> create the plpython3u extension without a problem.
>
> I then restored an existing DB (created in postgres 9.3). The
plpython3
> functions restored without a hitch and can execute.
>
>
> However, as soon as I try to create a NEW plpython3 function on
the db the
> postgres service terminates and does an auto-recovery.
>
> I then downgraded to postgres 9.4.4 and am still encountering
the same
> issue.
>
>
>
> Example:
>
> When running the following code:
>
> "create function test() returns void as $$ plpy.notice( 'xxx' );
$$ language
> plpython3u"
>
>
> the following is generated in the log:
>
> "
> 2016-03-31 09:36:56 CAT LOG: server process (PID 6376) exited
with exit
> code 3
> 2016-03-31 09:36:56 CAT DETAIL: Failed process was running:
create
> function test() returns void as $$ plpy.notice( 'xxx' ); $$
language
> plpython3u
> 2016-03-31 09:36:56 CAT LOG: terminating any other active
server processes
> 2016-03-31 09:36:56 CAT WARNING: terminating connection because
of crash of
> another server process
> 2016-03-31 09:36:56 CAT DETAIL: The postmaster has commanded
this server
> process to roll back the current transaction and exit, because
another
> server process exited abnormally and possibly corrupted shared
memory.
> 2016-03-31 09:36:56 CAT HINT: In a moment you should be able to
reconnect
> to the database and repeat your command.
> 2016-03-31 09:36:56 CAT WARNING: terminating connection because
of crash of
> another server process
> 2016-03-31 09:36:56 CAT DETAIL: The postmaster has commanded
this server
> process to roll back the current transaction and exit, because
another
> server process exited abnormally and possibly corrupted shared
memory.
> 2016-03-31 09:36:56 CAT HINT: In a moment you should be able to
reconnect
> to the database and repeat your command.
> 2016-03-31 09:36:56 CAT WARNING: terminating connection because
of crash of
> another server process
> 2016-03-31 09:36:56 CAT DETAIL: The postmaster has commanded
this server
> process to roll back the current transaction and exit, because
another
> server process exited abnormally and possibly corrupted shared
memory.
> 2016-03-31 09:36:56 CAT HINT: In a moment you should be able to
reconnect
> to the database and repeat your command.
>
> "
>
> I am guessing that my problem might have something to do with
the fact that
> the plpython2u language is not installed on the DB - although I
am not sure
> why it should it need it, when executing a plpython3 command. As I
> understand it, Postgres 9.4 accomodates both versions of python.
However I
> have not been able to figure out how to load plpython2u onto the
db. The
> postgres version I installed does not ship with plpython2.dll
and I have not
> been able to get hold of a copy. ( Python 2.7 /3.2 and 3.3 are
installed on
> my machine, and I am running postgre versions 9.2, 9.3 and
9.4.4 on
> different ports).
>
>
>
>
>
> --
> View this message in context:
http://postgresql.nabble.com/Postgres-9-4-4-9-4-6-plpython2-3-intallation-issues-on-a-Windows-7-machine-tp5896157.html
> Sent from the PostgreSQL - general mailing list archive at
Nabble.com.
>
>
Hello!
What postgres distr for Win are you using?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list ([hidden email]
<http:///user/SendEmail.jtp?type=node&node=5896174&i=0>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
------------------------------------------------------------------------
If you reply to this email, your message will be added to the
discussion below:
http://postgresql.nabble.com/Postgres-9-4-4-9-4-6-plpython2-3-intallation-issues-on-a-Windows-7-machine-tp5896157p5896174.html
To unsubscribe from Postgres 9.4.4/9.4.6: plpython2/3 intallation
issues on a Windows 7 machine, click here.
NAML
<http://postgresql.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
------------------------------------------------------------------------
View this message in context: Re: Postgres 9.4.4/9.4.6: plpython2/3
intallation issues on a Windows 7 machine
<http://postgresql.nabble.com/Postgres-9-4-4-9-4-6-plpython2-3-intallation-issues-on-a-Windows-7-machine-tp5896157p5896177.html>
Sent from the PostgreSQL - general mailing list archive
<http://postgresql.nabble.com/PostgreSQL-general-f1843780.html> at
Nabble.com.
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
