Обсуждение: initdb: failed
I have spent several days trying tofind the cause of this on google, but I am stumped. Thsi is the article I was using as a guideline: http://www.sitepoint.com/article/1233 I am running on Windows 2000 professional. ipc-daemon2 seems to start fien in the service window. The problem is when I log into windows as postgres. I rin the initdb -D command, it runs through its checks and then says initdb fails saying there is a lock file on the existing PID. There is no postmaster process runnign. I delete out the data directory to make sure there is no pid file, rerun initdb -D again and same thing. The versions of the software are the latest. I just downloaded them a coupel days ago. -- Let us not then pursue By force impossible, by leave obtained Unacceptable, though in Heav'n, our state Of splendid vassalage, but rather seek Our own good from ourselves, and from our own Live to ourselves, though in this vast recess, Free, and to none accountable, preferring Hard liberty before the easy yoke Of servile pomp. - Mammon, Paradise Lost
Ok, so what documentation should I be looking at for the current installation instructions? On Tue, 27 Jul 2004 03:30:26 +1000, Daniel Secomb <dan@ds-d.com> wrote: > You are using old commands. Cygwin no longer uses "ipc-daemon". Replace > ipc-daemon with "cygserver". > > For example: > > $ export CYGWIN=server > $ /usr/sbin/cygserver & > > See how you go. > > Kind Regards, > > Daniel Secomb > Creative Director > DS Design > ABN 33 721 455 978 > PO Box 4540, > Lake Haven NSW 2263 > Australia > [p] +61 2 4393 6305 > [f] +61 2 4393 6306 > [m] +61414 571 500 > mailto:dan@ds-d.com > http://www.ds-d.com/ > > Take a look at our latest web development project: > http://www.specialfx.com.au/ > > From the US, UK or Europe? Why not take advantage of the weaker Australian > dollar? Click the following link http://www.xe.com/ucc/ for a currency > conversion and find out how much you'll save!! > > _________________________________________________________________ > > The material contained in this email may be confidential, and may also be > the subject of copyright and/or privileged information. If you are not the > intended recipient, any use, disclosure or copying of this document is > prohibited. If you have received this document in error, please advise the > sender and delete the document. > > This email communication does not create or vary any contractual > relationship between DS Design and you. Internet communications are not > secure and accordingly DS Design does not accept any legal liability for the > contents of this message. > > Please note that neither DS Design nor the sender accepts any responsibility > for viruses and it is your responsibility to scan the email and any > attachments. > > > > > -----Original Message----- > From: pgsql-cygwin-owner@postgresql.org > [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Adam Lang > Sent: Tuesday, July 27, 2004 1:49 AM > To: pgsql-cygwin@postgresql.org > Subject: [CYGWIN] initdb: failed > > I have spent several days trying tofind the cause of this on google, > but I am stumped. > > Thsi is the article I was using as a guideline: > http://www.sitepoint.com/article/1233 > > I am running on Windows 2000 professional. ipc-daemon2 seems to start > fien in the service window. > > The problem is when I log into windows as postgres. I rin the initdb > -D command, it runs through its checks and then says initdb fails > saying there is a lock file on the existing PID. There is no > postmaster process runnign. I delete out the data directory to make > sure there is no pid file, rerun initdb -D again and same thing. > > The versions of the software are the latest. I just downloaded them a > coupel days ago. > -- > Let us not then pursue > By force impossible, by leave obtained > Unacceptable, though in Heav'n, our state > Of splendid vassalage, but rather seek > Our own good from ourselves, and from our own > Live to ourselves, though in this vast recess, > Free, and to none accountable, preferring > Hard liberty before the easy yoke > Of servile pomp. > - Mammon, Paradise Lost > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > -- Let us not then pursue By force impossible, by leave obtained Unacceptable, though in Heav'n, our state Of splendid vassalage, but rather seek Our own good from ourselves, and from our own Live to ourselves, though in this vast recess, Free, and to none accountable, preferring Hard liberty before the easy yoke Of servile pomp. - Mammon, Paradise Lost
I'm now going by this: http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README I am trying the first simple way to get the program started and if I can get that, figure I try the NT service route. When I try to initialize the database, I get: creating configuration files... ok creating template1 database in /var/postgresql/data/base/1... Signal 12 initdb: failed initdb: removing data directory "/var/postgresql/data" I installed the cygwin files, restarted the computer to make sure nothing was running and then went through the steps and I still get this. I am really lost, especially since no log files are generating. On Mon, 26 Jul 2004 13:41:08 -0400, Adam Lang <raider.adam@gmail.com> wrote: > Ok, so what documentation should I be looking at for the current > installation instructions? > > > > On Tue, 27 Jul 2004 03:30:26 +1000, Daniel Secomb <dan@ds-d.com> wrote: > > You are using old commands. Cygwin no longer uses "ipc-daemon". Replace > > ipc-daemon with "cygserver". > > > > For example: > > > > $ export CYGWIN=server > > $ /usr/sbin/cygserver & > > > > See how you go. > > > > Kind Regards, > > > > Daniel Secomb > > Creative Director > > DS Design > > ABN 33 721 455 978 > > PO Box 4540, > > Lake Haven NSW 2263 > > Australia > > [p] +61 2 4393 6305 > > [f] +61 2 4393 6306 > > [m] +61414 571 500 > > mailto:dan@ds-d.com > > http://www.ds-d.com/ > > > > Take a look at our latest web development project: > > http://www.specialfx.com.au/ > > > > From the US, UK or Europe? Why not take advantage of the weaker Australian > > dollar? Click the following link http://www.xe.com/ucc/ for a currency > > conversion and find out how much you'll save!! > > > > _________________________________________________________________ > > > > The material contained in this email may be confidential, and may also be > > the subject of copyright and/or privileged information. If you are not the > > intended recipient, any use, disclosure or copying of this document is > > prohibited. If you have received this document in error, please advise the > > sender and delete the document. > > > > This email communication does not create or vary any contractual > > relationship between DS Design and you. Internet communications are not > > secure and accordingly DS Design does not accept any legal liability for the > > contents of this message. > > > > Please note that neither DS Design nor the sender accepts any responsibility > > for viruses and it is your responsibility to scan the email and any > > attachments. > > > > > > > > > > -----Original Message----- > > From: pgsql-cygwin-owner@postgresql.org > > [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Adam Lang > > Sent: Tuesday, July 27, 2004 1:49 AM > > To: pgsql-cygwin@postgresql.org > > Subject: [CYGWIN] initdb: failed > > > > I have spent several days trying tofind the cause of this on google, > > but I am stumped. > > > > Thsi is the article I was using as a guideline: > > http://www.sitepoint.com/article/1233 > > > > I am running on Windows 2000 professional. ipc-daemon2 seems to start > > fien in the service window. > > > > The problem is when I log into windows as postgres. I rin the initdb > > -D command, it runs through its checks and then says initdb fails > > saying there is a lock file on the existing PID. There is no > > postmaster process runnign. I delete out the data directory to make > > sure there is no pid file, rerun initdb -D again and same thing. > > > > The versions of the software are the latest. I just downloaded them a > > coupel days ago. > > -- > > Let us not then pursue > > By force impossible, by leave obtained > > Unacceptable, though in Heav'n, our state > > Of splendid vassalage, but rather seek > > Our own good from ourselves, and from our own > > Live to ourselves, though in this vast recess, > > Free, and to none accountable, preferring > > Hard liberty before the easy yoke > > Of servile pomp. > > - Mammon, Paradise Lost > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > -- > Let us not then pursue > By force impossible, by leave obtained > Unacceptable, though in Heav'n, our state > Of splendid vassalage, but rather seek > Our own good from ourselves, and from our own > Live to ourselves, though in this vast recess, > Free, and to none accountable, preferring > Hard liberty before the easy yoke > Of servile pomp. > - Mammon, Paradise Lost > -- Let us not then pursue By force impossible, by leave obtained Unacceptable, though in Heav'n, our state Of splendid vassalage, but rather seek Our own good from ourselves, and from our own Live to ourselves, though in this vast recess, Free, and to none accountable, preferring Hard liberty before the easy yoke Of servile pomp. - Mammon, Paradise Lost
Adam Lang wrote: >I'm now going by this: >http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README > >I am trying the first simple way to get the program started and if I >can get that, figure I try the NT service route. > >When I try to initialize the database, I get: > >creating configuration files... ok >creating template1 database in /var/postgresql/data/base/1... Signal 12 > >initdb: failed >initdb: removing data directory "/var/postgresql/data" > >I installed the cygwin files, restarted the computer to make sure >nothing was running and then went through the steps and I still get >this. I am really lost, especially since no log files are generating. > > > Check out /var/log/postmaster.log What do the last lines say? Thanks! Best Regards, Carlo ------ Carlo Florendo y Flora Astra Philippines Inc. www.astra.ph
Nothing is being generated in log files. On Tue, 27 Jul 2004 08:23:39 +0800, Carlo Florendo <list-subscriber@hq.astra.ph> wrote: > Adam Lang wrote: > > >I'm now going by this: > >http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README > > > >I am trying the first simple way to get the program started and if I > >can get that, figure I try the NT service route. > > > >When I try to initialize the database, I get: > > > >creating configuration files... ok > >creating template1 database in /var/postgresql/data/base/1... Signal 12 > > > >initdb: failed > >initdb: removing data directory "/var/postgresql/data" > > > >I installed the cygwin files, restarted the computer to make sure > >nothing was running and then went through the steps and I still get > >this. I am really lost, especially since no log files are generating. > > > > > > > > Check out /var/log/postmaster.log > > What do the last lines say? > > Thanks! > > Best Regards, > > Carlo > ------ > Carlo Florendo y Flora > Astra Philippines Inc. > www.astra.ph > > -- Let us not then pursue By force impossible, by leave obtained Unacceptable, though in Heav'n, our state Of splendid vassalage, but rather seek Our own good from ourselves, and from our own Live to ourselves, though in this vast recess, Free, and to none accountable, preferring Hard liberty before the easy yoke Of servile pomp. - Mammon, Paradise Lost
Hello, The webpage listed below is not current. ipc-daemon2 is no longer used and cygserver is used in it's place. The readme included with the postgresql installation has the correct instructions. Mike On Mon, 2004-07-26 at 15:33, Adam Lang wrote: > I'm now going by this: > http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README > > I am trying the first simple way to get the program started and if I > can get that, figure I try the NT service route. > > When I try to initialize the database, I get: > > creating configuration files... ok > creating template1 database in /var/postgresql/data/base/1... Signal 12 > > initdb: failed > initdb: removing data directory "/var/postgresql/data" > > I installed the cygwin files, restarted the computer to make sure > nothing was running and then went through the steps and I still get > this. I am really lost, especially since no log files are generating. > > > > On Mon, 26 Jul 2004 13:41:08 -0400, Adam Lang <raider.adam@gmail.com> wrote: > > Ok, so what documentation should I be looking at for the current > > installation instructions? > > > > > > > > On Tue, 27 Jul 2004 03:30:26 +1000, Daniel Secomb <dan@ds-d.com> wrote: > > > You are using old commands. Cygwin no longer uses "ipc-daemon". Replace > > > ipc-daemon with "cygserver". > > > > > > For example: > > > > > > $ export CYGWIN=server > > > $ /usr/sbin/cygserver & > > > > > > See how you go. > > > > > > Kind Regards, > > > > > > Daniel Secomb > > > Creative Director > > > DS Design > > > ABN 33 721 455 978 > > > PO Box 4540, > > > Lake Haven NSW 2263 > > > Australia > > > [p] +61 2 4393 6305 > > > [f] +61 2 4393 6306 > > > [m] +61414 571 500 > > > mailto:dan@ds-d.com > > > http://www.ds-d.com/ > > > > > > Take a look at our latest web development project: > > > http://www.specialfx.com.au/ > > > > > > From the US, UK or Europe? Why not take advantage of the weaker Australian > > > dollar? Click the following link http://www.xe.com/ucc/ for a currency > > > conversion and find out how much you'll save!! > > > > > > _________________________________________________________________ > > > > > > The material contained in this email may be confidential, and may also be > > > the subject of copyright and/or privileged information. If you are not the > > > intended recipient, any use, disclosure or copying of this document is > > > prohibited. If you have received this document in error, please advise the > > > sender and delete the document. > > > > > > This email communication does not create or vary any contractual > > > relationship between DS Design and you. Internet communications are not > > > secure and accordingly DS Design does not accept any legal liability for the > > > contents of this message. > > > > > > Please note that neither DS Design nor the sender accepts any responsibility > > > for viruses and it is your responsibility to scan the email and any > > > attachments. > > > > > > > > > > > > > > > -----Original Message----- > > > From: pgsql-cygwin-owner@postgresql.org > > > [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Adam Lang > > > Sent: Tuesday, July 27, 2004 1:49 AM > > > To: pgsql-cygwin@postgresql.org > > > Subject: [CYGWIN] initdb: failed > > > > > > I have spent several days trying tofind the cause of this on google, > > > but I am stumped. > > > > > > Thsi is the article I was using as a guideline: > > > http://www.sitepoint.com/article/1233 > > > > > > I am running on Windows 2000 professional. ipc-daemon2 seems to start > > > fien in the service window. > > > > > > The problem is when I log into windows as postgres. I rin the initdb > > > -D command, it runs through its checks and then says initdb fails > > > saying there is a lock file on the existing PID. There is no > > > postmaster process runnign. I delete out the data directory to make > > > sure there is no pid file, rerun initdb -D again and same thing. > > > > > > The versions of the software are the latest. I just downloaded them a > > > coupel days ago. > > > -- > > > Let us not then pursue > > > By force impossible, by leave obtained > > > Unacceptable, though in Heav'n, our state > > > Of splendid vassalage, but rather seek > > > Our own good from ourselves, and from our own > > > Live to ourselves, though in this vast recess, > > > Free, and to none accountable, preferring > > > Hard liberty before the easy yoke > > > Of servile pomp. > > > - Mammon, Paradise Lost > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: you can get off all lists at once with the unregister command > > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > > > > > -- > > Let us not then pursue > > By force impossible, by leave obtained > > Unacceptable, though in Heav'n, our state > > Of splendid vassalage, but rather seek > > Our own good from ourselves, and from our own > > Live to ourselves, though in this vast recess, > > Free, and to none accountable, preferring > > Hard liberty before the easy yoke > > Of servile pomp. > > - Mammon, Paradise Lost > > >
Adam Lang wrote: >Nothing is being generated in log files. > >On Tue, 27 Jul 2004 08:23:39 +0800, Carlo Florendo ><list-subscriber@hq.astra.ph> wrote: > > >>Adam Lang wrote: >> >> >> >>>I'm now going by this: >>>http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README >>> >>>I am trying the first simple way to get the program started and if I >>>can get that, figure I try the NT service route. >>> >>>When I try to initialize the database, I get: >>> >>>creating configuration files... ok >>>creating template1 database in /var/postgresql/data/base/1... Signal 12 >>> >>>initdb: failed >>>initdb: removing data directory "/var/postgresql/data" >>> >>>I installed the cygwin files, restarted the computer to make sure >>>nothing was running and then went through the steps and I still get >>>this. I am really lost, especially since no log files are generating. >>> >>> >>> Ok then. I've written a tutorial on how to configure postgresql on Cygwin. I'm soon going to propose the tutorial to be included in the postgresql docs. In the meantime, check it out: http://www.geocities.com/cfflorendo/postgresql-cygwin.html Thanks! Best Regards, Carlo ------ Carlo Florendo y Flora Astra Philippines Inc. www.astra.ph
I am still failign on initdb. I followed the instructions to the letter. I uninstalled cygwin and did it from scratch. This is what I am getting. Also, no log file is being created in /var/log. either. Signal 12 Signal 12 50 creating configuration files... ok creating template1 database in /var/postgresql/data/base/1... Signal 12 initdb: failed postgres@napoleon ~ On Tue, 27 Jul 2004 11:34:03 +0800, Carlo Florendo <list-subscriber@hq.astra.ph> wrote: > Adam Lang wrote: > > >Nothing is being generated in log files. > > > >On Tue, 27 Jul 2004 08:23:39 +0800, Carlo Florendo > ><list-subscriber@hq.astra.ph> wrote: > > > > > >>Adam Lang wrote: > >> > >> > >> > >>>I'm now going by this: > >>>http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README > >>> > >>>I am trying the first simple way to get the program started and if I > >>>can get that, figure I try the NT service route. > >>> > >>>When I try to initialize the database, I get: > >>> > >>>creating configuration files... ok > >>>creating template1 database in /var/postgresql/data/base/1... Signal 12 > >>> > >>>initdb: failed > >>>initdb: removing data directory "/var/postgresql/data" > >>> > >>>I installed the cygwin files, restarted the computer to make sure > >>>nothing was running and then went through the steps and I still get > >>>this. I am really lost, especially since no log files are generating. > >>> > >>> > >>> > > Ok then. I've written a tutorial on how to configure postgresql on > Cygwin. I'm soon going to propose the tutorial to be included in the > postgresql docs. > In the meantime, check it out: > > http://www.geocities.com/cfflorendo/postgresql-cygwin.html > > > > Thanks! > > Best Regards, > > Carlo > ------ > Carlo Florendo y Flora > Astra Philippines Inc. > www.astra.ph > > -- Back to thy punishment, False fugitive, and to thy speed add wings, Lest with a whip of scorpions I pursue Thy ling'ring, or with one stroek fo this dart Strange horror sieze thee, and pangs unfelt before. - Sin, Paradise Lost
I got it working. Thsi time when I removed cygwin, I removed the
registry entries for it also. Restarted the computer and reinstalled
it again. It went liek gold this time with the following
instructions:
1. Install and configure cygserver:
$ cygserver-config
2. Start cygserver:
$ cygserver &
3. Initialize PostgreSQL:
$ initdb -D /var/postgresql/data
4. Start the PostgreSQL postmaster:
$ postmaster -D /var/postgresql/data &
5. Connect to PostgreSQL:
$ psql template1
Now that it is working fine, I will set up to do it with a better user
account and as a service.
On Tue, 27 Jul 2004 11:17:09 -0400, Adam Lang <raider.adam@gmail.com> wrote:
> I am still failign on initdb. I followed the instructions to the
> letter. I uninstalled cygwin and did it from scratch. This is what I
> am getting. Also, no log file is being created in /var/log. either.
>
> Signal 12
> Signal 12
> 50
> creating configuration files... ok
> creating template1 database in /var/postgresql/data/base/1... Signal 12
>
> initdb: failed
>
> postgres@napoleon ~
>
> On Tue, 27 Jul 2004 11:34:03 +0800, Carlo Florendo
>
>
> <list-subscriber@hq.astra.ph> wrote:
> > Adam Lang wrote:
> >
> > >Nothing is being generated in log files.
> > >
> > >On Tue, 27 Jul 2004 08:23:39 +0800, Carlo Florendo
> > ><list-subscriber@hq.astra.ph> wrote:
> > >
> > >
> > >>Adam Lang wrote:
> > >>
> > >>
> > >>
> > >>>I'm now going by this:
> > >>>http://www.tishler.net/jason/software/postgresql/postgresql-7.4.README
> > >>>
> > >>>I am trying the first simple way to get the program started and if I
> > >>>can get that, figure I try the NT service route.
> > >>>
> > >>>When I try to initialize the database, I get:
> > >>>
> > >>>creating configuration files... ok
> > >>>creating template1 database in /var/postgresql/data/base/1... Signal 12
> > >>>
> > >>>initdb: failed
> > >>>initdb: removing data directory "/var/postgresql/data"
> > >>>
> > >>>I installed the cygwin files, restarted the computer to make sure
> > >>>nothing was running and then went through the steps and I still get
> > >>>this. I am really lost, especially since no log files are generating.
> > >>>
> > >>>
> > >>>
> >
> > Ok then. I've written a tutorial on how to configure postgresql on
> > Cygwin. I'm soon going to propose the tutorial to be included in the
> > postgresql docs.
> > In the meantime, check it out:
> >
> > http://www.geocities.com/cfflorendo/postgresql-cygwin.html
> >
> >
> >
> > Thanks!
> >
> > Best Regards,
> >
> > Carlo
> > ------
> > Carlo Florendo y Flora
> > Astra Philippines Inc.
> > www.astra.ph
> >
> >
>
>
> --
> Back to thy punishment,
> False fugitive, and to thy speed add wings,
> Lest with a whip of scorpions I pursue
> Thy ling'ring, or with one stroek fo this dart
> Strange horror sieze thee, and pangs unfelt before.
> - Sin, Paradise Lost
>
--
Back to thy punishment,
False fugitive, and to thy speed add wings,
Lest with a whip of scorpions I pursue
Thy ling'ring, or with one stroek fo this dart
Strange horror sieze thee, and pangs unfelt before.
- Sin, Paradise Lost