<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>I can connect fine using psql and a <span style="font-family: 'Times New Roman'; font-size: 12pt;">select version(); responds with</span><div><span style="font-family: 'Times New Roman'; font-size: 12pt;">--------------------------------------------------------------------------------------------------------------</span></div><div><h1><font face="Times New Roman" style="font-weight: normal;" size="3"> PostgreSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.6.3 20120306 (Red Hat 4.6.3-2), 64-bit</font></h1></div><div><font face="Times New Roman" style="font-weight: normal;" size="3">I have also created the PostGIS extension on the DB I've created in the RDS version through PGADMIN.</font></div><div><font face="Times New Roman" style="font-weight: normal;" size="3"><br></font></div><div><font face="Times New Roman" style="font-weight: normal;" size="3">Tried exporting PGPASSWORD but still no joy. Having it exported stops the password prompt and the psql connection is still fine.</font></div><div><font face="Times New Roman" style="font-weight: normal;" size="3"><br></font></div><div><font face="Times New Roman" style="font-weight: normal;" size="3">The errors.txt file is empty based on the commands line in previous mail.</font></div><div><font face="Times New Roman" style="font-weight: normal;" size="3"><br></font></div><div><font face="Times New Roman" size="3">If I remove the target DB from the command line the errors.txt has a FATAL db does not exist error.</font></div><div><font face="Times New Roman" size="3">If I remove the target DB from postgresql through PGADMIN and run the command line, errors.txt contains the FATAL db does not exist error.</font></div><div><font face="Times New Roman" size="3">If I change the user the errors.txt file populates with a user error.</font></div><div><font face="Times New Roman" size="3"><br></font></div><div><font face="Times New Roman" size="3">So the RDS platform is getting connected to but it would seem that the pipe dies because when the PGPASSWORD is set and users are correct and DB's in place the process starts but dies immediately with no error messages.</font></div><div><font face="Times New Roman" size="3"><br></font></div><div><font face="Times New Roman" size="3">Will continue to search for what next.</font></div><div><font face="Times New Roman" size="3"><br></font></div><div><font face="Times New Roman" size="3">Thanks again,</font></div><div><font face="Times New Roman" size="3"><br></font></div><div><font face="Times New Roman" size="3">Paul</font></div><div><br></div><div><font face="Times New Roman" size="3"><br></font></div> </div></body>
</html>