[GENERAL] Installing plpython3u

Hello, I'm having problems installing plpython3u, this is my situation: I have installed postgresql-9.3.5 in my home directory, from source. I used (from my memory, it might not be exact) ./configure --prefix=$HOME; make; make install Now I need to upload a database which requires plpython3u, an

Re: [GENERAL] Installing plpython3u

ure? I see there is a "--with-python" option (not specific to python3 though). If it matters, my python 3 is in /usr/local/bin/python3. On 15 October 2015 at 14:20, Adrian Klaver wrote: > On 10/15/2015 03:21 AM, Dario Beraldi wrote: > >> Hello, >> >> I'm

Re: [GENERAL] Installing plpython3u

On 15 October 2015 at 14:46, Tom Lane wrote: > Dario Beraldi writes: > > Thanks for your answer. Just checking before I screw things up... About > > "the source tree has to be configured and built twice", does it mean > that I > > have to execute again > >

Re: [GENERAL] Installing plpython3u

> createlang plpython3u sblab >>> ERROR: could not open extension control file >>> >>> "/data/sblab-home/berald01/share/postgresql/extension/plpython3u.control": >>> No such file or directory >>> STATEMENT: CREATE EXTENSION "plpython3u"; >>> >> >> Hmm, what files *do* you have in that directory >

Re: [GENERAL] Installing plpython3u

> > It might be worth cd'ing into the src/pl/plpython subdirectory and >> manually doing "make install" there to see what it prints. >> >> >> By the way, that's what I see in src/pl/plpython: ls -l /data/sblab-home/berald01/applications/postgresql/postgresql-9.3.5/src/pl/plpython total 292 drwxrwx

Re: [GENERAL] Installing plpython3u

On 15 October 2015 at 16:23, Tom Lane wrote: > Dario Beraldi writes: > >> It might be worth cd'ing into the src/pl/plpython subdirectory and > >> manually doing "make install" there to see what it prints. > > > Here we go: > > cd >

Re: [GENERAL] Installing plpython3u

On 15 October 2015 at 16:29, Dario Beraldi wrote: > > > > > > On 15 October 2015 at 16:23, Tom Lane wrote: > >> Dario Beraldi writes: >> >> It might be worth cd'ing into the src/pl/plpython subdirectory and >> >> manually doing "

[GENERAL] Can the query planner create indexes?

ification much appreciated! All the best and Christmas wishes! Dario -- Dr. Dario Beraldi Institute of Evolutionary Biology University of Edinburgh West Mains Road Edinburgh EH9 3JT Scotland, UK -- The University of Edinburgh is a charitable body, registered in Scotland, with registrati

Re: [GENERAL] Can the query planner create indexes?

Ok, thanks a lot to all of you for your answers! (Always impressed by the prompt feedback you get on this list!) Quoting Gabriele Bartolini : Ciao Dario, On Tue, 21 Dec 2010 09:14:36 +, Dario Beraldi wrote: the query run better the planner is not able (allowed?) to create such index

[GENERAL] Cluster table and order information

with COPY a datafile which is already correctly sorted, can I inform postgres of such order, so that no clustering is necessary after the import? In other words, how can I tell postgres that my file is order by this and that column? Many thanks! Dario -- Dr. Dario Beraldi Institute of

Re: [GENERAL] Cluster table and order information

Quoting Andy Colson : On 2/1/2011 9:08 AM, Dario Beraldi wrote: Hello, From the documentation of CLUSTER table (http://www.postgresql.org/docs/8.4/static/sql-cluster.html) I understand that clustering can be achieved by re-creating the table like this: CREATE TABLE newtable AS SELECT * FROM

[GENERAL] postgres for OLAP & data mining

Hello, I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of - What tools/SQL commands are available? - How should postgres be configured? - How suitable is

Re: [GENERAL] postgres for OLAP & data mining

fact, I was rather wondering whether there are dedicated packages for OLAP and some guidelines for configuring postgres (and whether postgres is a good option for OLAP). Best Dario > On Fri, Sep 30, 2011 at 10:12 AM, Dario Beraldi > wrote: > >> Hello, >> >> I

[GENERAL] plpython on postgresql 9.1

Hello, I have installed postgresql on a mac using the 'one click' installer (postgresql-9.1.1-1-osx.dmg). I then tried to import the python language but I get the error: create language plpythonu; ERROR: could not access file "$libdir/plpython2": No such file or directory Can you help me in fig

[GENERAL] Visualize database schema

Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or database (essentially the output of pg_dump) and pr

Re: [GENERAL] Visualize database schema

Many thanks to everybody for advice! I'll give it a go to the tools you suggested. Dario On 14 August 2012 09:54, Dario Beraldi wrote: > Hello, > > Apologies if this question has been asked before, but I couldn't come up > with a decent solution... > > Can a

[GENERAL] postgres.conf settings

abase specific issue, but even some general pointers would help me... Many thanks! Dario -- Dr. Dario Beraldi Institute of Evolutionary Biology University of Edinburgh West Mains Road Edinburgh EH9 3JT Scotland, UK -- The University of Edinburgh is a charitable body, registered in Scotland,

Re: [GENERAL] postgres.conf settings

;m a geneticist/bioinformatician using postgresql to manage the data I or others produce. I'm not a proper database programmer who run a web server. Many thanks for all and any feedback! Dario -- Dr. Dario Beraldi Institute of Evolutionary Biology University of Edinburgh West Mains R