I686LINUX/util/I686LINUX/doc/postgresql/html/install-post.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Post-Installation Setup</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="  Installation Instructions"
  16 HREF="installation.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="Installation Procedure"
  19 HREF="install-procedure.html"><LINK
  20 REL="NEXT"
  21 TITLE="Supported Platforms"
  22 HREF="supported-platforms.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="install-procedure.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="installation.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 14. Installation Instructions</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="installation.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="supported-platforms.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="SECT1"
  92 ><H1
  93 CLASS="SECT1"
  94 ><A
  95 NAME="INSTALL-POST"
  96 >14.6. Post-Installation Setup</A
  97 ></H1
  98 ><DIV
  99 CLASS="SECT2"
 100 ><H2
 101 CLASS="SECT2"
 102 ><A
 103 NAME="AEN14594"
 104 >14.6.1. Shared Libraries</A
 105 ></H2
 106 ><A
 107 NAME="AEN14596"
 108 ></A
 109 ><P
 110 >    On some systems that have shared libraries (which most systems do)
 111     you need to tell your system how to find the newly installed
 112     shared libraries.  The systems on which this is
 113     <SPAN
 114 CLASS="emphasis"
 115 ><I
 116 CLASS="EMPHASIS"
 117 >not</I
 118 ></SPAN
 119 > necessary include <SPAN
 120 CLASS="SYSTEMITEM"
 121 >BSD/OS</SPAN
 122 >, <SPAN
 123 CLASS="SYSTEMITEM"
 124 >FreeBSD</SPAN
 125 >,
 126     <SPAN
 127 CLASS="SYSTEMITEM"
 128 >HP-UX</SPAN
 129 >, <SPAN
 130 CLASS="SYSTEMITEM"
 131 >IRIX</SPAN
 132 >, <SPAN
 133 CLASS="SYSTEMITEM"
 134 >Linux</SPAN
 135 >,
 136     <SPAN
 137 CLASS="SYSTEMITEM"
 138 >NetBSD</SPAN
 139 >, <SPAN
 140 CLASS="SYSTEMITEM"
 141 >OpenBSD</SPAN
 142 >, <SPAN
 143 CLASS="SYSTEMITEM"
 144 >Tru64
 145     UNIX</SPAN
 146 > (formerly <SPAN
 147 CLASS="SYSTEMITEM"
 148 >Digital UNIX</SPAN
 149 >), and
 150     <SPAN
 151 CLASS="SYSTEMITEM"
 152 >Solaris</SPAN
 153 >.
 154    </P
 155 ><P
 156 >    The method to set the shared library search path varies between
 157     platforms, but the most widely usable method is to set the
 158     environment variable <TT
 159 CLASS="ENVAR"
 160 >LD_LIBRARY_PATH</TT
 161 > like so: In Bourne
 162     shells (<TT
 163 CLASS="COMMAND"
 164 >sh</TT
 165 >, <TT
 166 CLASS="COMMAND"
 167 >ksh</TT
 168 >, <TT
 169 CLASS="COMMAND"
 170 >bash</TT
 171 >, <TT
 172 CLASS="COMMAND"
 173 >zsh</TT
 174 >)
 175 </P><PRE
 176 CLASS="PROGRAMLISTING"
 177 >LD_LIBRARY_PATH=/usr/local/pgsql/lib
 178 export LD_LIBRARY_PATH</PRE
 179 ><P>
 180     or in <TT
 181 CLASS="COMMAND"
 182 >csh</TT
 183 > or <TT
 184 CLASS="COMMAND"
 185 >tcsh</TT
 186 >
 187 </P><PRE
 188 CLASS="PROGRAMLISTING"
 189 >setenv LD_LIBRARY_PATH /usr/local/pgsql/lib</PRE
 190 ><P>
 191     Replace <TT
 192 CLASS="LITERAL"
 193 >/usr/local/pgsql/lib</TT
 194 > with whatever you set
 195     <VAR
 196 CLASS="OPTION"
 197 ><TT
 198 CLASS="LITERAL"
 199 >--libdir</TT
 200 ></VAR
 201 > to in <A
 202 HREF="install-procedure.html#CONFIGURE"
 203 >step 1</A
 204 >.
 205     You should put these commands into a shell start-up file such as
 206     <TT
 207 CLASS="FILENAME"
 208 >/etc/profile</TT
 209 > or <TT
 210 CLASS="FILENAME"
 211 >~/.bash_profile</TT
 212 >.  Some
 213     good information about the caveats associated with this method can
 214     be found at <A
 215 HREF="http://www.visi.com/~barr/ldpath.html"
 216 TARGET="_top"
 217 >http://www.visi.com/~barr/ldpath.html</A
 218 >.
 219    </P
 220 ><P
 221 >    On some systems it might be preferable to set the environment
 222     variable <TT
 223 CLASS="ENVAR"
 224 >LD_RUN_PATH</TT
 225 > <SPAN
 226 CLASS="emphasis"
 227 ><I
 228 CLASS="EMPHASIS"
 229 >before</I
 230 ></SPAN
 231 >
 232     building.
 233    </P
 234 ><P
 235 >    On <SPAN
 236 CLASS="SYSTEMITEM"
 237 >Cygwin</SPAN
 238 >, put the library
 239     directory in the <TT
 240 CLASS="ENVAR"
 241 >PATH</TT
 242 > or move the
 243     <TT
 244 CLASS="FILENAME"
 245 >.dll</TT
 246 > files into the <TT
 247 CLASS="FILENAME"
 248 >bin</TT
 249 >
 250     directory.
 251    </P
 252 ><P
 253 >    If in doubt, refer to the manual pages of your system (perhaps
 254     <TT
 255 CLASS="COMMAND"
 256 >ld.so</TT
 257 > or <TT
 258 CLASS="COMMAND"
 259 >rld</TT
 260 >). If you later
 261     on get a message like
 262 </P><PRE
 263 CLASS="SCREEN"
 264 >psql: error in loading shared libraries
 265 libpq.so.2.1: cannot open shared object file: No such file or directory</PRE
 266 ><P>
 267     then this step was necessary.  Simply take care of it then.
 268    </P
 269 ><P
 270 >    <A
 271 NAME="AEN14640"
 272 ></A
 273 >
 274     If you are on <SPAN
 275 CLASS="SYSTEMITEM"
 276 >BSD/OS</SPAN
 277 >, <SPAN
 278 CLASS="SYSTEMITEM"
 279 >Linux</SPAN
 280 >, or <SPAN
 281 CLASS="SYSTEMITEM"
 282 >SunOS 4</SPAN
 283 >
 284     and you have root access you can run
 285 </P><PRE
 286 CLASS="PROGRAMLISTING"
 287 >/sbin/ldconfig /usr/local/pgsql/lib</PRE
 288 ><P>
 289     (or equivalent directory) after installation to enable the
 290     run-time linker to find the shared libraries faster.  Refer to the
 291     manual page of <TT
 292 CLASS="COMMAND"
 293 >ldconfig</TT
 294 > for more information.  On
 295     <SPAN
 296 CLASS="SYSTEMITEM"
 297 >FreeBSD</SPAN
 298 >, <SPAN
 299 CLASS="SYSTEMITEM"
 300 >NetBSD</SPAN
 301 >, and <SPAN
 302 CLASS="SYSTEMITEM"
 303 >OpenBSD</SPAN
 304 > the command is
 305 </P><PRE
 306 CLASS="PROGRAMLISTING"
 307 >/sbin/ldconfig -m /usr/local/pgsql/lib</PRE
 308 ><P>
 309     instead.  Other systems are not known to have an equivalent
 310     command.
 311    </P
 312 ></DIV
 313 ><DIV
 314 CLASS="SECT2"
 315 ><H2
 316 CLASS="SECT2"
 317 ><A
 318 NAME="AEN14651"
 319 >14.6.2. Environment Variables</A
 320 ></H2
 321 ><A
 322 NAME="AEN14653"
 323 ></A
 324 ><P
 325 >    If you installed into <TT
 326 CLASS="FILENAME"
 327 >/usr/local/pgsql</TT
 328 > or some other
 329     location that is not searched for programs by default, you should
 330     add <TT
 331 CLASS="FILENAME"
 332 >/usr/local/pgsql/bin</TT
 333 > (or whatever you set
 334     <VAR
 335 CLASS="OPTION"
 336 ><TT
 337 CLASS="LITERAL"
 338 >--bindir</TT
 339 ></VAR
 340 > to in <A
 341 HREF="install-procedure.html#CONFIGURE"
 342 >step 1</A
 343 >)
 344     into your <TT
 345 CLASS="ENVAR"
 346 >PATH</TT
 347 >.  Strictly speaking, this is not
 348     necessary, but it will make the use of <SPAN
 349 CLASS="PRODUCTNAME"
 350 >PostgreSQL</SPAN
 351 >
 352     much more convenient.
 353    </P
 354 ><P
 355 >    To do this, add the following to your shell start-up file, such as
 356     <TT
 357 CLASS="FILENAME"
 358 >~/.bash_profile</TT
 359 > (or <TT
 360 CLASS="FILENAME"
 361 >/etc/profile</TT
 362 >, if you
 363     want it to affect every user):
 364 </P><PRE
 365 CLASS="PROGRAMLISTING"
 366 >PATH=/usr/local/pgsql/bin:$PATH
 367 export PATH</PRE
 368 ><P>
 369     If you are using <TT
 370 CLASS="COMMAND"
 371 >csh</TT
 372 > or <TT
 373 CLASS="COMMAND"
 374 >tcsh</TT
 375 >, then use this command:
 376 </P><PRE
 377 CLASS="PROGRAMLISTING"
 378 >set path = ( /usr/local/pgsql/bin $path )</PRE
 379 ><P>
 380    </P
 381 ><P
 382 >    <A
 383 NAME="AEN14672"
 384 ></A
 385 >
 386     To enable your system to find the <SPAN
 387 CLASS="APPLICATION"
 388 >man</SPAN
 389 >
 390     documentation, you need to add lines like the following to a
 391     shell start-up file unless you installed into a location that is
 392     searched by default.
 393 </P><PRE
 394 CLASS="PROGRAMLISTING"
 395 >MANPATH=/usr/local/pgsql/man:$MANPATH
 396 export MANPATH</PRE
 397 ><P>
 398    </P
 399 ><P
 400 >    The environment variables <TT
 401 CLASS="ENVAR"
 402 >PGHOST</TT
 403 > and <TT
 404 CLASS="ENVAR"
 405 >PGPORT</TT
 406 >
 407     specify to client applications the host and port of the database
 408     server, overriding the compiled-in defaults. If you are going to
 409     run client applications remotely then it is convenient if every
 410     user that plans to use the database sets <TT
 411 CLASS="ENVAR"
 412 >PGHOST</TT
 413 >.  This
 414     is not required, however: the settings can be communicated via command
 415     line options to most client programs.
 416    </P
 417 ></DIV
 418 ></DIV
 419 ><DIV
 420 CLASS="NAVFOOTER"
 421 ><HR
 422 ALIGN="LEFT"
 423 WIDTH="100%"><TABLE
 424 SUMMARY="Footer navigation table"
 425 WIDTH="100%"
 426 BORDER="0"
 427 CELLPADDING="0"
 428 CELLSPACING="0"
 429 ><TR
 430 ><TD
 431 WIDTH="33%"
 432 ALIGN="left"
 433 VALIGN="top"
 434 ><A
 435 HREF="install-procedure.html"
 436 ACCESSKEY="P"
 437 >Prev</A
 438 ></TD
 439 ><TD
 440 WIDTH="34%"
 441 ALIGN="center"
 442 VALIGN="top"
 443 ><A
 444 HREF="index.html"
 445 ACCESSKEY="H"
 446 >Home</A
 447 ></TD
 448 ><TD
 449 WIDTH="33%"
 450 ALIGN="right"
 451 VALIGN="top"
 452 ><A
 453 HREF="supported-platforms.html"
 454 ACCESSKEY="N"
 455 >Next</A
 456 ></TD
 457 ></TR
 458 ><TR
 459 ><TD
 460 WIDTH="33%"
 461 ALIGN="left"
 462 VALIGN="top"
 463 >Installation Procedure</TD
 464 ><TD
 465 WIDTH="34%"
 466 ALIGN="center"
 467 VALIGN="top"
 468 ><A
 469 HREF="installation.html"
 470 ACCESSKEY="U"
 471 >Up</A
 472 ></TD
 473 ><TD
 474 WIDTH="33%"
 475 ALIGN="right"
 476 VALIGN="top"
 477 >Supported Platforms</TD
 478 ></TR
 479 ></TABLE
 480 ></DIV
 481 ></BODY
 482 ></HTML
 483 >