[GENERAL] DateStyle is Postgres with US (NonEuropean) conventions

[Marcos Lloret]

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] NOTICE: DateStyle is Postgres with Eropean convention

[Marcos Lloret]

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] existing but not-existing database.

[Marcos Lloret]

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

[Marcos Lloret]

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]