Обсуждение: Install different directory issues
I installed Postgres to /app and now psql command not working under Postgres user along with not knowing how to start the service like with a traditional systemctl.
RHEL7
Postgres 10.11
Thanks for any help!
-- Tom Carter
On 11/27/19 10:49 AM, Thomas Carter wrote: > I installed Postgres to /app and now psql command not working under > Postgres user along with not knowing how to start the service like with > a traditional systemctl. Installed using source, package, other and from where? > > RHEL7 > Postgres 10.11 > > Thanks for any help! > -- > Tom Carter -- Adrian Klaver adrian.klaver@aklaver.com
I installed using the Postgres Installer package available on the Postgres site. With the system setup, I had to installto /app. I choose to use the installer because yum wouldn’t allow for me to choose a different install destination. I’m not sure if I would have the same issue right now if I used rpm —prefix. Tom Carter > On Nov 27, 2019, at 2:00 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: > > On 11/27/19 10:49 AM, Thomas Carter wrote: >> I installed Postgres to /app and now psql command not working under Postgres user along with not knowing how to startthe service like with a traditional systemctl. > > Installed using source, package, other and from where? > >> RHEL7 >> Postgres 10.11 >> Thanks for any help! >> -- >> Tom Carter > > > -- > Adrian Klaver > adrian.klaver@aklaver.com
Hi Thomas
did you make sure the search paths and the paths in the config files were updated to find postgresql files. I've seen this not get updated by the install scripts
On Wed, Nov 27, 2019 at 2:20 PM Thomas Carter <reckless2k2@gmail.com> wrote:
I installed using the Postgres Installer package available on the Postgres site. With the system setup, I had to install to /app. I choose to use the installer because yum wouldn’t allow for me to choose a different install destination.
I’m not sure if I would have the same issue right now if I used rpm —prefix.
Tom Carter
> On Nov 27, 2019, at 2:00 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 11/27/19 10:49 AM, Thomas Carter wrote:
>> I installed Postgres to /app and now psql command not working under Postgres user along with not knowing how to start the service like with a traditional systemctl.
>
> Installed using source, package, other and from where?
>
>> RHEL7
>> Postgres 10.11
>> Thanks for any help!
>> --
>> Tom Carter
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
On 11/27/19 11:19 AM, Thomas Carter wrote: > I installed using the Postgres Installer package available on the Postgres site. With the system setup, I had to installto /app. I choose to use the installer because yum wouldn’t allow for me to choose a different install destination. There is more then one installer, which one? Do you have another instance of Postgres installed? > > I’m not sure if I would have the same issue right now if I used rpm —prefix. > > Tom Carter > >> On Nov 27, 2019, at 2:00 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote: >> >> On 11/27/19 10:49 AM, Thomas Carter wrote: >>> I installed Postgres to /app and now psql command not working under Postgres user along with not knowing how to startthe service like with a traditional systemctl. >> >> Installed using source, package, other and from where? >> >>> RHEL7 >>> Postgres 10.11 >>> Thanks for any help! >>> -- >>> Tom Carter >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com
I'm not that knowledgeable of Redhat paths
here is how i would start
first find the daemon or systemd postgresql.service files. on debian these are located in /etc/init.d or /etc/systemd if the files exist modify them to the correct paths if they do not exist the install went very side-ways uninstall and and try again and read help files regarding the command line switches to change the install path
If the the files are and paths are correct the something else went wrong. either failed to register the daemon or initdb failed which will cause the service to fail to start.
try to start postgres from the command prompt. it will throw errors giving you an idea what the problem is
on debian logs are located in /var/log/postgresql/versionnumber/
On Wed, Nov 27, 2019 at 3:58 PM Thomas Carter <reckless2k2@gmail.com> wrote:
Hi Justin,I expect this is the case since the traditional install will have everything “fall” into the right place. How would I correct since I’ve installed to the /app directory?Thanks for your help.--On Wed, Nov 27, 2019 at 2:26 PM Justin <zzzzz.graf@gmail.com> wrote:Hi Thomasdid you make sure the search paths and the paths in the config files were updated to find postgresql files. I've seen this not get updated by the install scriptsOn Wed, Nov 27, 2019 at 2:20 PM Thomas Carter <reckless2k2@gmail.com> wrote:I installed using the Postgres Installer package available on the Postgres site. With the system setup, I had to install to /app. I choose to use the installer because yum wouldn’t allow for me to choose a different install destination.
I’m not sure if I would have the same issue right now if I used rpm —prefix.
Tom Carter
> On Nov 27, 2019, at 2:00 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 11/27/19 10:49 AM, Thomas Carter wrote:
>> I installed Postgres to /app and now psql command not working under Postgres user along with not knowing how to start the service like with a traditional systemctl.
>
> Installed using source, package, other and from where?
>
>> RHEL7
>> Postgres 10.11
>> Thanks for any help!
>> --
>> Tom Carter
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.comTom Carter