User Tools

Site Tools


sqlonalldatabases

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
sqlonalldatabases [2023/09/06 12:06] sweitmannsqlonalldatabases [2024/09/25 06:21] (current) – external edit 127.0.0.1
Line 9: Line 9:
   my $driver   = "Pg";   my $driver   = "Pg";
   my $database = "postgres";   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 = "";   my $password = "";
      
Line 33: Line 33:
      
       for my $db (@$dbs) {       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            my $dbh          = DBI->connect( $database_dsn, $userid, $password, { RaiseError => 0, PrintError 
   => 0 } );   => 0 } );
sqlonalldatabases.1694001960.txt.gz · Last modified: 2024/09/25 06:20 (external edit)