pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problems with select version
2+ messages / 2 participants
[nested] [flat]

* Problems with select version
@ 2004-06-30 15:08 Vaughn, Adam (IMS) <VaughnA@imsweb.com>
  2004-07-01 21:50 ` Re: Problems with select version Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Vaughn, Adam (IMS) @ 2004-06-30 15:08 UTC (permalink / raw)
  To: pgsql-admin

Sorry to bother you but I was unable to find this problem after looking
through the mailing list. I have postgres setup up on UNIX and I
configured the appropriate files and followed the steps from the manual.
After I initialized the database server and started the postmaster I
attempted to query template1 for the version number. Every time I run
select version(); I get 0 rows returned. I also ran the query select *
from pg_database which returned no rows, shouldn't template1 at least be
in there? Did I miss a step, or is there any way to initialize these
values. I am attempting to connect to this database using pgAdmin 3 but
the select version() is failing because template1 is returning no rows.
Any help would be appreciated.

Thanks,
Adam



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Problems with select version
  2004-06-30 15:08 Problems with select version Vaughn, Adam (IMS) <VaughnA@imsweb.com>
@ 2004-07-01 21:50 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-07-01 21:50 UTC (permalink / raw)
  To: Vaughn, Adam (IMS) <VaughnA@imsweb.com>; +Cc: pgsql-admin

"Vaughn, Adam (IMS)" <VaughnA@imsweb.com> writes:
> Sorry to bother you but I was unable to find this problem after looking
> through the mailing list. I have postgres setup up on UNIX and I
> configured the appropriate files and followed the steps from the manual.
> After I initialized the database server and started the postmaster I
> attempted to query template1 for the version number. Every time I run
> select version(); I get 0 rows returned.

*Something's* awfully broken then.  I'd suggest rebuilding from scratch
... and try the regression tests.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-01 21:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-30 15:08 Problems with select version Vaughn, Adam (IMS) <VaughnA@imsweb.com>
2004-07-01 21:50 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox