Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Netdisco Psql custom command (Muris)
2. Re: Netdisco Psql custom command (Andy Ruhl)
--- Begin Message ---
Hi Oliver, I get this
[netdisco@ bin]$ psql
bash: psql: command not found
From: Oliver Gorwits <[email protected]>
Date: Sunday, 30 August 2020 at 06:55
To: Muris <[email protected]>
Cc: "[email protected]"
<[email protected]>
Subject: Re: [Netdisco] Netdisco Psql custom command
Hi,
I guess my first question would be: can you run just "psql" by itself as the
netdisco user? Perhaps the netdisco user needs to be added to a group, if not.
Netdisco literally just calls "psql" as you would do, at the command line:
https://github.com/netdisco/netdisco/blob/master/lib/App/Netdisco/Worker/Plugin/Psql.pm#L39
regards,
oliver.
On Sat, 29 Aug 2020 at 00:24, Muris <[email protected]> wrote:
Hi,
I am used to using this query to get a status of devices scanned within the
last 2 weeks, but since I upgraded to postgresql 12, it stopped working.
How can I make it work again?
[netdisco@]$ ./netdisco-do psql -e "select ip, name from device where creation
> now() - interval '2 weeks'"
info App::Netdisco version 2.046002 loaded.
info psql: started at Sat Aug 29 08:47:55 2020
Can't exec "psql": Permission denied at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Psql.pm line 39.
info psql: finished at Sat Aug 29 08:47:55 2020
info psql: status done: psql session closed.
Thankyou
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
On Mon, Aug 31, 2020 at 2:46 AM Muris <[email protected]> wrote:
>
> Hi Oliver, I get this
>
>
>
> [netdisco@ bin]$ psql
>
> bash: psql: command not found
Usually the Postgres server and client packages are separate. It could
be that during the upgrade of the server, the client package was
removed. Please investigate how to re-install the Postgres client
package on your operating system.
Andy
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
