Hi,
I want to run new postgres version with chroot in old environment.
I have compiled postgres, took related stuff and tried to run it.
The command works fine as below :
[root@manage /root]# /usr/sbin/chroot /var/newrootpg usr/local/pgsql/bin/initdb --help
initdb initializes a PostgreSQL database cluster.
Usage:
initdb [OPTION]... [DATADIR]
Options:
-A, --auth=METHOD default authentication method for local connections
[-D, --pgdata=]DATADIR location for this database cluster
-E, --encoding=ENCODING set default encoding for new databases
--locale=LOCALE set default locale for new databases
--lc-collate=, --lc-ctype=, --lc-messages=LOCALE
--lc-monetary=, --lc-numeric=, --lc-time=LOCALE
set default locale in the respective category for
new databases (default taken from environment)
--no-locale equivalent to --locale=C
--pwfile=FILE read password for the new superuser from file
-T, --text-search-config=CFG
default text search configuration
-U, --username=NAME database superuser name
-W, --pwprompt prompt for a password for the new superuser
-X, --xlogdir=XLOGDIR location for the transaction log directory
Less commonly used options:
-d, --debug generate lots of debugging output
-L DIRECTORY where to find the input files
-n, --noclean do not clean up after errors
-s, --show show internal settings
Other options:
-?, --help show this help, then exit
-V, --version output version information, then exit
If the data directory is not specified, the environment variable PGDATA
is used.
Report bugs to <pgsql-bugs@postgresql.org>.
But it creates problem when I actually use it to create a database
[root@manage /root]# /usr/sbin/chroot /var/newrootpg /usr/local/pgsql/bin/initdb -D /var/pgsql/data2
fgets failure: No such file or directory
The program "postgres" is needed by initdb but was not found in the
same directory as "/usr/local/pgsql/bin/initdb".
Check your installation.
where as postgres already exists in that folder,
[root@manage /root]# /usr/sbin/chroot /var/newrootpg /usr/local/pgsql/bin/postgres --version
postgres (PostgreSQL) 9.1.1
So why its unable to find postgres ? Any solution for this ?
Thanks in Advance.
