Re: [Postgres-xc-developers] Database postgres-xc is not created anymore - please help

[Himpich, S. <Ste...@se...>]

Hi all,

I thought the postgres-xc database is needed for XC operation and therefor was worried. If it is optional (or well just default db of psql), everything is fine. Thanks for your feedback!

Greetings,
Stefan


-----Original Message-----
From: Koichi Suzuki [mailto:koi...@gm...]
Sent: Tue 8/20/2013 3:06 AM
To: Himpich, Stefan
Cc: pgxc-hackers mailing list
Subject: Re: [Postgres-xc-developers] Database postgres-xc is not created anymore - please help
 
I suppose that "init all" command is successful first, then tried to run
psql and found this message.   Your pgxc_ctl log shows this.   The database
"postgres-xc" is the default database when you run psql (or pgxc_ctl's
Psql).   Unfortunately, this database is not created automatically by
pgxc_ctl's init command.  You should run createdb (or pgxc_ctl's Createdb)
command to create it, or you should supply database name to use to psql or
Psql command such as:
pgxc# Createdb postgres-xc

Or you can supply other existing database name to psql or Psql as:
pgxc$ Psql postgres

Good luck;
---
Koichi Suzuki



2013/8/12 Himpich, Stefan <Ste...@se...>

> Hi Guys,
>
> I have a problem. While upgrading to latest sources last week, my testbed
> stopped working. I get the error message:
>
> FATAL:  3D000: database "postgres-xc" does not exist
>
> I get this message on all datanodes and all coordinators. GMT Log shows no
> errors.
>
>
> I have no idea where this problem comes from and would be greatful for any
> hints!
>
>
> Attached you find the pgxc_ctl.conf, the logfile from the init all run and
> the output of show configuration all
>
> I included the full Logfile from the datanode-master (node dbms181 on
> server dbms181) in this message.
>
>
>
> Greetings,
> Stefan
>
>
> Full Logfile from Datanode-Master:
> LOG:  00000: database system was shut down at 2013-08-12 13:25:44 UTC
> LOCATION:  StartupXLOG, xlog.c:6344
> LOG:  00000: database system is ready to accept connections
> LOCATION:  reaper, postmaster.c:2560
> LOG:  00000: autovacuum launcher started
> LOCATION:  AutoVacLauncherMain, autovacuum.c:407
> LOG:  00000: connection received: host=gtm81 port=60914
> LOCATION:  BackendInitialize, postmaster.c:3666
> LOG:  00000: connection authorized: user=postgres-xc database=postgres-xc
> LOCATION:  PerformAuthentication, postinit.c:229
> FATAL:  3D000: database "postgres-xc" does not exist
> LOCATION:  InitPostgres, postinit.c:716
> LOG:  00000: connection received: host=dbms297 port=38572
> LOCATION:  BackendInitialize, postmaster.c:3666
> LOG:  00000: replication connection authorized: user=postgres-xc
> LOCATION:  PerformAuthentication, postinit.c:225
> LOG:  00000: checkpoint starting: force wait
> LOCATION:  LogCheckpointStart, xlog.c:7902
> LOG:  00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction
> log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s,
> total=0.365 s; sync files=0, longest=0.000 s, average=0.000 s
> LOCATION:  LogCheckpointEnd, xlog.c:7990
> Warning: Permanently added 'dbms297,10.182.201.109' (ECDSA) to the list of
> known hosts.
> Warning: Permanently added 'dbms297,10.182.201.109' (ECDSA) to the list of
> known hosts.
> LOG:  00000: disconnection: session time: 0:00:04.583 user=postgres-xc
> database= host=dbms297 port=38572
> LOCATION:  log_disconnections, postgres.c:4707
> Warning: Permanently added 'dbms297,10.182.201.109' (ECDSA) to the list of
> known hosts.
> LOG:  00000: connection received: host=gtm81 port=60950
> LOCATION:  BackendInitialize, postmaster.c:3666
> LOG:  00000: connection authorized: user=postgres-xc database=postgres-xc
> LOCATION:  PerformAuthentication, postinit.c:229
> FATAL:  3D000: database "postgres-xc" does not exist
> LOCATION:  InitPostgres, postinit.c:716
> LOG:  00000: connection received: host=dbms297 port=38573
> LOCATION:  BackendInitialize, postmaster.c:3666
> LOG:  00000: replication connection authorized: user=postgres-xc
> LOCATION:  PerformAuthentication, postinit.c:225
> LOG:  00000: connection received: host=gtm81 port=60983
> LOCATION:  BackendInitialize, postmaster.c:3666
> LOG:  00000: connection authorized: user=postgres-xc database=postgres-xc
> LOCATION:  PerformAuthentication, postinit.c:229
> FATAL:  3D000: database "postgres-xc" does not exist
> LOCATION:  InitPostgres, postinit.c:716
>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>