Tag: postgresql

WILDFLY/JBOSS: POSTGRESQL AND MYSQL DATASOURCE CONFIGURATION

Posted on By Andre Dias No Comments on WILDFLY/JBOSS: POSTGRESQL AND MYSQL DATASOURCE CONFIGURATION
database, server

ENVIRONMENT Java 13 Wildfly 18 Windows 10 / *Nix  (also applicable adapting the commands) DRIVER CONFIGURATION The trick is to match the requirements of the participants. They are: – the application server’s (the way it requires the configuration) – the target database version (type of database and version) – the driver compatible with the target … Read More “WILDFLY/JBOSS: POSTGRESQL AND MYSQL DATASOURCE CONFIGURATION” »

POSTGRESQL: RESTORING DATABASES WITH DIFFERENT USER FROM THE CURRENT WINDOWS USER

Posted on By Andre Dias No Comments on POSTGRESQL: RESTORING DATABASES WITH DIFFERENT USER FROM THE CURRENT WINDOWS USER
database

Your current user on Windows doesn’t let you perform a PostgreSQL’s command? Some PostgreSQL commands like createdb, pg_restore, etc. works assuming the current user logged on the console (or system). This approach makes simple things; Unfortunately, many times, the current user doesn’t exist on the database, mainly when restoring legacy databases. On *Nix environment, it … Read More “POSTGRESQL: RESTORING DATABASES WITH DIFFERENT USER FROM THE CURRENT WINDOWS USER” »