Differences

This shows you the differences between two versions of the page.

--- sqlonalldatabases [2023/09/06 12:06] – sweitmann
+++ sqlonalldatabases [2023/09/06 12:21] (current) – sweitmann
@@ Line 9: / Line 9: @@
   my $driver   = "Pg";
   my $database = "postgres";
-  my $dsn      = "DBI:$driver:dbname=$database;host=localhost";
+  my $dsn      = "DBI:$driver:dbname=$database";
-  my $userid   = "postgres";
+  my $userid   = "sql-ledger";
   my $password = "";
@@ Line 33: / Line 33: @@
       for my $db (@$dbs) {
-          my $database_dsn = "DBI:$driver:dbname=$db;host=localhost";
+          my $database_dsn = "DBI:$driver:dbname=$db";
           my $dbh          = DBI->connect( $database_dsn, $userid, $password, { RaiseError => 0, PrintError
   => 0 } );