473,324 Members | 2,178 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

stand-alone psql

I'm looking for a way to build psql on OS X so that it can be copied to
another computer without any external dependencies. In particular, if I
build the standard distribution and then copy psql to another computer,
I get an error that /mydir/.../lib/libpq.3.dylib cannot be found. This
is probably basic make stuff, but I'm not sure where to start.

I think I solved this on Windows (8.0 beta) just by keeping libpq.dll
and zlib.dll in the same directory with psql.exe. Please correct me if
there is more to it.

Thanks,

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
2 2358
John DeSoi wrote:
I'm looking for a way to build psql on OS X so that it can be copied
to another computer without any external dependencies. In particular,
if I build the standard distribution and then copy psql to another
computer, I get an error that /mydir/.../lib/libpq.3.dylib cannot be
found. This is probably basic make stuff, but I'm not sure where to
start.


You could link psql statically. You would have to look up in your
compiler/linker manual how to do that though. The relevant makefile is
in src/bin/psql. Setting LDFLAGS globally to some option like -static
might work.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

On Sep 1, 2004, at 11:51 AM, Peter Eisentraut wrote:
You could link psql statically. You would have to look up in your
compiler/linker manual how to do that though. The relevant makefile is
in src/bin/psql. Setting LDFLAGS globally to some option like -static
might work.


Right, this was my thinking but I was hoping for a little more
direction from some one familiar with C. I have already spent hours
working on it and have not been able to get it to work. The task is
pretty daunting for some one without a strong background with
gcc/ld/make.

I thought I had it solved by putting the dynamic libraries in the psql
folder and using install_name_tool to change the paths. But when I
moved the folder from a 10.3 to a 10.2 Mac, I got an error about a
missing symbol in /usr/lib/libSystem.B.dylib (the library is there on
10.2, but I guess it is an older version). When I include the newer
libSystem.B.dylib with psql I get an error when I try to start it:

*** vm_page_shift incorrectly set to 12

Thanks for any further ideas or pointers.

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: AstrA | last post by:
Hi All My forms are gonig to have a dark to green background and I want my labels to stand out. I'm gonig to use white for the colour of the actual labels, but you see a lot of the...
25
by: Ben | last post by:
Hi all! I learned Python as part of my university coursework... I enjoyed it. Now I'm just wondering how Python compares with asp, jsp, php and what not?? I don't have slightest knowledge about...
1
by: gicio | last post by:
HI! I have a little problem: I have change the administrator password (Windows 2003 Server) which MS SQL 2000 use to login. And now the SQL server can't stand up. What should I do? thx!
0
by: Peter Sands | last post by:
Hi, I have setup a stand-by db2 DB server, I want to test the log shipping method. Do I just issue a 'list history..' on the source server to get the logs I need to ship. Then copy those logs...
1
by: Tony Do | last post by:
Hi every, Which version of DB2 (Work group Or Enterprise) can I use as a stanby server? Under Window Do I need Windows server enterprise version?
1
by: E. Robert Tisdale | last post by:
Acronym Finder: http://it.acronymfinder.com/af-query.asp?string=exact&acronym=rtfm
6
by: Robert Smith | last post by:
I am programming C in linux and i just need a quick and dirty way to make some text stand out. I would like to change the color maybe to red. I want to print out something like printf("Blah:...
5
by: John Creighton | last post by:
What does BCPL stand for is it one language or a family of languages. My bust guess it the B C Programming Languages. But that is just a short in the dark. I am also not sure what languages fall...
4
by: Greg | last post by:
Regarding extensibility, e.g. EnvDTE what does "DTE" stand for? -- Greg McPherran www.McPherran.com
1
by: =?Utf-8?B?U3R1YXJ0TA==?= | last post by:
The PC running Windows XP Home SP2 is put into Stand By. After coming out of Stand By, I try to start an internet connection, using Tiscali Broadband. A dialogue box is displayed with the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.