On 6/19/20 12:26 PM, Pepe TD Vo wrote:
thank you for all the information but I have no problem connecting to
the database using pgAdmin and/or directly psql from the postgres database.
I need to set up a batch/cron job to run in Linux/AWS to ingest the
data. Therefore pgadmin GUI is not an option. I used pgAdmin to create
tables, triggers, function triggers and manual importing/exporting. You
can't schedule a time to run importing from csv file(s) using pgAdmin
as same OEM.
There is pgAgent:
https://www.pgadmin.org/docs/pgadmin4/development/pgagent.html
The select table in this question is just an example for me to create
scripting to see it connect or not. No one at work to manually run the
script and enter the password. Need to bypass it like Oracle
scripting. Since this is not an option to put the password to connect
to the database and run the script(s), we will find another way to do.
But there is an option.
I am thankful for all the input.
v/r,
**
*Bach-Nga
*No one in this world is pure and perfect. If you avoid people for
their mistakes you will be alone. So judge less, love, and forgive
more.EmojiEmojiEmoji
To call him a dog hardly seems to do him justice though in as much as he
had four legs, a tail, and barked, I admit he was, to all outward
appearances. But to those who knew him well, he was a perfect gentleman
(Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Friday, June 19, 2020, 02:24:05 PM EDT, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx> wrote:
On 6/19/20 8:30 AM, cgerard999@xxxxxxxxx <mailto:cgerard999@xxxxxxxxx>
wrote:
> There is an alternate solution, which is to launch pgadmin GUI, connect
> to the database, tick « save password »
> Then psql won’t prompt fir password any more.
Pretty sure that is only within the context of pgAdmin.
> Pay however attention to the security concern.
>
> Sent from my mobile phone
>
>> Le 19 juin 2020 à 17:07, Pepe TD Vo <pepevo@xxxxxxxxx
<mailto:pepevo@xxxxxxxxx>> a écrit :
>>
>>
>> appreciate for clarification, all inputs and teaching me more in
>> PostgreSQL
>>
>> have a good weekend and happy father's day to all who is Father.
>>
>> v/r,
>>
>> **
>> *Bach-Nga
>>
>> *No one in this world is pure and perfect. If you avoid people for
>> their mistakes you will be alone. So judge less, love, and forgive
>> more.EmojiEmojiEmoji
>> To call him a dog hardly seems to do him justice though in as much as
>> he had four legs, a tail, and barked, I admit he was, to all outward
>> appearances. But to those who knew him well, he was a perfect
>> gentleman (Hermione Gingold)
>>
>> **Live simply **Love generously **Care deeply **Speak kindly.
>> *** Genuinely rich *** Faithful talent *** Sharing success
>>
>>
>>
>>
>> On Friday, June 19, 2020, 10:57:59 AM EDT, Adrian Klaver
>> <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
>>
>>
>> On 6/19/20 7:52 AM, David G. Johnston wrote:
>> > On Fri, Jun 19, 2020 at 6:58 AM Adrian Klaver
>> <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>
>> > <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
>> <mailto:adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>>> wrote:
>> >
>> > On 6/19/20 6:53 AM, Pepe TD Vo wrote:
>> > > Thank you sir and I am sorry for the typo not having "--" on
>> > password.
>> > > I did spelling out with --password=mypassword
>> >
>> > Please go back and read my post again.
>> >
>> >
>> > To be clear, there is no way to supply a password as a command line
>> > argument. It is fundamentally a bad idea and we don't even make it an
>> > option.
>>
>> Actually that is not entirely true, see my follow up post.
>>
>> >
>> > You need to decide on one of the actual ways of supplying a
>> password, or
>> > choose an alternative authentication method like peer.
>> >
>> > David J.
>>
>> >
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>
>>
>>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
