Hi, I have a puzzling issue when trying to migrate a database. The database was previously set up under Postgres 9.5.3 on Windows 10 using activeperl latest version with DBD:Pg.

The target environment for the migration is Ubuntu 14.04. The latest version of Postgres for this appears to be 9.3. The Perl version it has is 5.18.2.

After apt-get install of Postgres, defaulting to 9.3, PgAdminIII, cpan installation of DBI, DateTime and DBD:Pg, I created the databases with the same names, roles and passwords as the Windows installation, using pgsql. I can log on from pgsql, but neither the postgres user or the roles can log in from DBI, behaving as if the username and password are wrong, but I am sure they are not. I get the same kind of problem from PgAdminIII, so it isn't just Perl but PgAdminIII suffering the same problem. I checked the Postgres configuration files and there is nothing wrong there. It isn't a network problem because all access methods above were local. I checked for having more than one installed version of Postgres, which would explain it, but no, there is only one. So the problem appears to lie under the hood somewhere, not obviously in DBI otherwise pgadmin would work, but I am not sure where to look next. All suggestions are welcome! Thanks!

One world, one people

In reply to Postgres + Perl + Ubuntu by anonymized user 468275

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.