![]() Psql -h. -U demo_user -d dev -p 5439 -f d:\demo\redshift_script.sql -L d:\demo\log_redshift_script.logĪll commands in redshift_script.sql file would get executed in PSQL and logs will be stored in log_redshift_script. Make sure to change below parameters highlighted in red for your cluster endpoint, userid, copy script file name and log script file name respectively Make sure to add this to your PATH environment variable Select command line tools as shown in below screenshot and install thatĪbove will install postgres12 command line in below folder C:\Program Files\PostgreSQL\12\bin. Run the installer which will take few minutes and prompt you for installations options Personally I find unzip to be the best "installer" anyway (I also use that to install the Postgres server, the Windows installer just has too many quirks)īelow are the steps I followed to connect to Amazon Redshift with postgres12 psql on windows:ĭownload postgres 12.4 from below location: It is obviously not a real installer, but if you put the cleaned up directory into a ZIP file, you can distribute that and whoever needs it just unzips the archive. Of course you can also take all that from an existing Postgres installation without the need to download the ZIP archive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |