Re: Problem Creating Databases...
От | David Heebner |
---|---|
Тема | Re: Problem Creating Databases... |
Дата | |
Msg-id | 9vvfsf$1bro$1@news.tht.net обсуждение исходный текст |
Список | pgsql-general |
Hi Steve, I installed the ipc-daemon, but maybe I should try re-installing? I dunno. Everything else seems to be working OK - I can connect to databases once I've created them (locally and remotely): use pgAdmin, add tables, INSERT data, perform SQL on them, etc. What's the best way to re-install ipc-daemon? Thanks, Dave "Steve Brett" <steve.brett@e-mis.com> wrote in message news:9vv46l$19rn$1@news.tht.net... > did you install the ipc-daemon ? > > Steve > "David Heebner" <dave@franklinsecurity.com> wrote in message > news:9vqof5$b7l$1@news.tht.net... > > Hi, > > > > I'm running 7.1.3 under Windows NT 4 as a service. I followed the > > instructions as per Jason Tishler's doc on installing cygwin and > PostgreSQL > > under NT as a service. Everything seems to be working fine, with the > > exception of creating new databases. If I run cygwin as the postgres user > > and create a database (either using createdb or CREATE DATABASE under a > > working database), then I cannot connect to it using psql. I get an error > > that states: "The database subdirectory > > '/usr/share/postgresql/data/base/111111' is missing." This goes for using > > pgAdmin II as well (can create the db, but cannot connect to it to create > > tables, etc.). > > > > I have found a workaround, which is to stop the NT postmaster service, > then > > manually start postmaster in cygwin shell under postgres account. > > > > Then I can create the database(s) and shutdown postmaster, then start the > NT > > service again. I can then successfully connect to the databases and > create > > tables, etc. using pgAdmin, or psql. It seems as if there is something > > wrong with the service but I cannot figure out what. The 'postgres' > account > > is a local account and the server is not a domain controller, just a > member > > server. > > > > Any thoughts? > > > > Dave Heebner > > > > > >
В списке pgsql-general по дате отправления: