usr/local/Cellar/postgresql/9.0.4/share/postgresql/ Though, I did do this: >sudo find / -name "*nf*" This seems odd: > egrep 'listen|port' /usr/local/var/postgres/nfĮgrep: /usr/local/var/postgres/nf: No such file or directory Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process.
ASTRALINUX POSTGRESQL MAC UPDATE
Update 5: sudo pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start > pg_ctl -D /usr/local/var/postgres status Here are the contents: # IPv4 local connections:īut I don't understand this: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I found that there wasn't any pg_hba.conf file (only file pg_), so I modified the sample and renamed it (to remover the. Update 3: > pg_ctl -D /usr/local/var/postgres status Is the server running on host "localhost" and accepting The touch was not successful, so I did this instead: > mkdir /usr/local/var/postgresīut when I try to start the Ruby on Rails server, I still see this: Sh: /usr/local/var/postgres/server.log: No such file or directory Update: > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I see that postgres is not running > ps auxwww | grep postgres This is not required, however the settings can be communicated via command line options to most client programs.I had forgotten to run the initdb command.īy running this command ps auxwww | grep postgres If you are going to run client applications remotely then it is convenient if every user that plans to use the database sets PGHOST. The environment variables PGHOST and PGPORT specify to client applications the host and port of the database server, overriding the compiled-in defaults. MANPATH=/usr/local/pgsql/share/man:$MANPATH To enable your system to find the man documentation, you need to add lines like the following to a shell start-up file unless you installed into a location that is searched by default: Set path = ( /usr/local/pgsql/bin $path ) If you are using csh or tcsh, then use this command: To do this, add the following to your shell start-up file, such as ~/.bash_profile (or /etc/profile, if you want it to affect all users): Strictly speaking, this is not necessary, but it will make the use of PostgreSQL much more convenient. If you installed into /usr/local/pgsql or some other location that is not searched for programs by default, you should add /usr/local/pgsql/bin (or whatever you set -bindir to in Step 1) into your PATH. Other systems are not known to have an equivalent command. On FreeBSD, NetBSD, and OpenBSD the command is:
ASTRALINUX POSTGRESQL MAC MANUAL
Refer to the manual page of ldconfig for more information. (or equivalent directory) after installation to enable the run-time linker to find the shared libraries faster. If you are on Linux and you have root access, you can run: Libpq.so.2.1: cannot open shared object file: No such file or directory If in doubt, refer to the manual pages of your system (perhaps ld.so or rld). On Cygwin, put the library directory in the PATH or move the. On some systems it might be preferable to set the environment variable LD_RUN_PATH before building. Some good information about the caveats associated with this method can be found at. You should put these commands into a shell start-up file such as /etc/profile or ~/.bash_profile.
Replace /usr/local/pgsql/lib with whatever you set -libdir to in Step 1. Setenv LD_LIBRARY_PATH /usr/local/pgsql/lib The method to set the shared library search path varies between platforms, but the most widely-used method is to set the environment variable LD_LIBRARY_PATH like so: In Bourne shells ( sh, ksh, bash, zsh): The systems on which this is not necessary include FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, and Solaris.
ASTRALINUX POSTGRESQL MAC HOW TO
On some systems with shared libraries you need to tell the system how to find the newly installed shared libraries.
0 kommentar(er)
