Database/PostgreSQL9 postgresql jdbc test code import java.sql.DriverManager;import java.sql.Connection;import java.sql.SQLException; public class Example1 { public static void main(String[] argv) { System.out.println("Checking if Driver is registered with DriverManager."); try { Class.forName("org.postgresql.Driver"); } catch (ClassNotFoundException cnfe) { System.out.println("Couldn't find the driver!"); System.out.println("Let's print a s.. 2016. 7. 25. create super user with password on postgresql postgres@ubuntu:~$ createuser -P -s -e test 새 롤의 암호:암호 확인:CREATE ROLE test PASSWORD 'md5f3084041c7669071a1dc54c05d3658cd' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN; 2016. 7. 25. * No PostgreSQL clusters exist; see "man pg_createcluster" * No PostgreSQL clusters exist; see "man pg_createcluster" locale 확인 sudo dpkg-reconfigure locales Afterpg_createcluster 9.X main --start 2016. 7. 25. psql: FATAL: Peer authentication failed for user taiga@ubuntu:~$ psql -U testUser -W testDB -h localhost psql: FATAL: Peer authentication failed for user 옵션에 -h localhost를 붙여준다. 2016. 6. 27. 이전 1 2 3 다음