Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
pgadmin3 1.2 and 1.3 for postgresql 8.0+
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks
View previous topic :: View next topic  
Author Message
uodeltasig
n00b
n00b


Joined: 20 Mar 2004
Posts: 48
Location: Eugene, OR

PostPosted: Fri Mar 18, 2005 8:38 am    Post subject: pgadmin3 1.2 and 1.3 for postgresql 8.0+ Reply with quote

I found the install and setup for pgadmin3-1.2, which is needed for postgresql 8.0+, to be quite tricky so I documented the steps I took to get it up and running. Also, the very few post out there don't realy offer too many specific gentoo related answers.

What's needed:
    wxGTK-2.5.3+ or wxX11-2.5.3+
    postgresql-7.3 or postgresql-8.0
    pgadmin3
    about 1 1/2 hour of compile time on a 700 mhz laptop


Setup / Bugs this solution currently has:
I couldn't get it to work correctly with existing gentoo wxGTK-2.4.4 install so you will have to remove wxGTK which will break amule if you use it.
Code:
su
unmerge wxGTK



Setup wxGTK:

First step Installing wxGTK (for this solution I chose wxGTK):

Download the package (I used version 2.5.4):
http://www.wxwidgets.org/dl_gtk.htm#dev

Extract and make:
Code:
tar -zxf wxGTK-2.5.4.tar.gz
cd wxGTK-2.5.4
./configure --with-gtk --enable-gtk2 --enable-unicode --disable-shared --enable-debug --enable-mimetype=no --enable-xrc
make
make install
ldconfig


Build XRC package
Code:
# Within the wxGTK directory
cd contrib/src/stc/
make all && make install


Update the OGL lib and build OGL package
Code:

nano contrib/include/wx/ogl/basic.h
# Change line 20 from
#define wxUSE_DEPRECATED 1 to
#define wxUSE_DEPRECATED 0
cd contrib/src/ogl
make all && make install


Setup pgadmin3

Now you are ready to get the If you wish to use CVS code:
Code:
CVSROOT=:pserver:anonymous@cvs.pgadmin.org:/projects export CVSROOT
cvs login
cvs -z9 checkout pgadmin3
cd pgadmin3
sh bootstrap


OR the latest source tarball:

Code:
wget http://www.pgadmin.org/snapshots/pgadmin3-src.tar.gz
tar -zxvf pgadmin3-src.tar.gz
cd pgadmin3pgadmin3 package


Now build and enjoy no errors hopefully on gentoo
Code:
./configure --enable-static --enable-debug
 make all
 make install



Then you can add the symbolic link to the new executable
Code:
ln -sf /usr/local/pgadmin3/bin/pgadmin3 /usr/bin/pgadmin3


* After it is installed it should be easy to reemerge wxGTK-2.4.4 for other programs like amule

* Credits *
This tutorial extends upon the install instructions included with the CVS copy of pgadmin3 and adds in some important additions for gentoo
Back to top
View user's profile Send private message
BServiss
n00b
n00b


Joined: 24 Nov 2002
Posts: 62

PostPosted: Mon May 09, 2005 12:24 am    Post subject: Reply with quote

To save someone else a little time, pgadmin3 version 1.0.x doesn't work with Postgresql 8.0+.

If you see:

Code:
ERROR: column "datpath" does not exist


then most likely you have the incorrect version of pgadmin3. Which is, of course, the version marked stable in portage :)

Bug report to follow..
Back to top
View user's profile Send private message
gna
n00b
n00b


Joined: 19 Mar 2003
Posts: 38
Location: Beijing

PostPosted: Mon May 09, 2005 2:02 am    Post subject: Reply with quote

There is already a bug report

By the way pgadmin3 version 1.2.1 was released at the end of march but they just put it in the download area and not on the news page.

WxGTK 2.6.0 has been released and is in testing so perhaps this pgadmin3 problem can be resolved soon
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum