[GENERAL] NOTICE: DateStyle is Postgres with Eropean convention
hi list, i have restart postgresql with postmaster -i -o -e & and every time the servlets (via web) are accesing to posgres database it shows, in the shell, this: NOTICE: DateStyle is Postgres with European conventions thanks marcos [EMAIL PROTECTED]
[GENERAL] DateStyle is Postgres with US (NonEuropean) conventions
hi list, i have start postgresql doingpostmaster -i & and this is what i am getting in the shell. NOTICE: DateStyle is Postgres with US (NonEuropean) conventions NOTICE: DateStyle is Postgres with US (NonEuropean) conventions NOTICE: DateStyle is Postgres with US (NonEuropean) conventions NOTICE: DateStyle is Postgres with US (NonEuropean) conventions and continuos. does anyone know how can start postgres to prevent from this? thanks. marcos [EMAIL PROTECTED]
[GENERAL] existing but not-existing database.
hi, i created a database called todojamon. (i wanted to make up of an old database trying to copy the same directoy to ../base/todojamon as before). but it does not work. i deleted the directory. now i want to restart the procedure creating a new database called todojamon. but it answers > psql todojamon FATAL 1: Database 'todojamon' does not exist. We know this because the directory '/usr/local/pgsql/data/base/todojamon' does not exist. You can create a database with the SQL command CREATE DATABASE. To see what databases exist, look at the subdirectories of '/usr/local/pgsql/data/base/'. Connection to database 'todojamon' failed. FATAL 1: Database 'todojamon' does not exist. We know this because the directory '/usr/local/pgsql/data/base/todojamon' does not exist. You can create a database with the SQL command CREATE DATABASE. To see what databases exist, look at the subdirectories of '/usr/local/pgsql/data/base/'. if > psql template1 [inside postgres] template1=> create database todojamon; ERROR: createdb: database 'todojamon' already exists ERROR: createdb: database 'todojamon' already exists how can i delete todojamon database?? thanks in advance. marcos [EMAIL PROTECTED]
[GENERAL] troubles installing postgresql6.4
hi, i do not know what superuser account i made. so i am not able to do initdb.. it says.. We are initializing the database system with username X (uid=500). This user will own all the files and must also own the server process. mkdir: cannot create directory `/usr/local/pgsql/data/base/template1': Relaying denied. Creating template database in /usr/local/pgsql/data/base/template1 ERROR: cannot create pg_proc ERROR: cannot create pg_proc initdb: could not create template database initdb: cleaning up by wiping out /usr/local/pgsql/data/base/template1 what should i do thanks in advance, marcos [EMAIL PROTECTED]