agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedno response from backend with new dbs
2+ messages / 2 participants
[nested] [flat]
* no response from backend with new dbs
@ 1994-09-26 09:31 alfredos@tamu.edu
0 siblings, 1 reply; 2+ messages in thread
From: alfredos@tamu.edu @ 1994-09-26 09:31 UTC (permalink / raw)
To: legacy
I can use any databases that already exist but when I create
a new one I get no response from the backend. I have tried
killing and restarting the postmaster and ipccleaning without
any success. Any suggestions anyone?
Thanks in advance,
-J. Alfredo Sanchez. alfredo@bush.cs.tamu.edu
________________________________________________________________________
P.S. I am using postgres 4.1. An example session follows:
hrl6%> monitor asmtest
Welcome to the C POSTGRES terminal monitor
Go
* retrieve (Objects.all)\g
Query sent to backend is "retrieve (Objects.all)"
-----------------------------
| id | components |
-----------------------------
| 59552 | 0 |
-----------------------------
| 60224 | (null) |
-----------------------------
| 76718 | 0 |
-----------------------------
Go
* \q
I live to serve you.
hrl6%> createdb newdb
hrl6%> monitor newdb
Welcome to the C POSTGRES terminal monitor
Go
* create Objects(id=oid, components=oid) \g
Query sent to backend is "create create Objects(id=oid, components=oid) "
Error: No response from the backend, exiting...
hrl6%>
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: no response from backend with new dbs
@ 1994-09-27 00:33 Kai Petzke <wpp@marie.physik.tu-berlin.de>
parent: alfredos@tamu.edu
0 siblings, 0 replies; 2+ messages in thread
From: Kai Petzke @ 1994-09-27 00:33 UTC (permalink / raw)
To: alfredos <alfredos@tamu.edu>; +Cc: legacy
>
>
> I can use any databases that already exist but when I create
> a new one I get no response from the backend. I have tried
> killing and restarting the postmaster and ipccleaning without
> any success. Any suggestions anyone?
I can think of two possible reasons:
- your template1 database is corrupted. template1 holds an empty
database structure, which is copied to the new database by
createdb.
- one of your system files, like pg_database, is corrupted.
In either case, I recommend you to "copy out" the complete
database structure, recreate everything from scratch (with
initdb; you won't probably have to recompile postgres), and
re-load the database with "copy in".
Kai
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-09-27 00:33 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-09-26 09:31 no response from backend with new dbs alfredos@tamu.edu
1994-09-27 00:33 ` Kai Petzke <wpp@marie.physik.tu-berlin.de>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox