royalanjr has asked for the wisdom of the Perl Monks concerning the following question:

I know this is not a perl question; but I have no doubt that several of you have had experience with PostgreSQL.

I am trying to install PostgreSQL 7.0.2 on a Linux box. I have the directory structure /usr/local/pgsql owned by the postgres superuser. The libraries and executables and data directories are under this tree. I also have the source directory under here so that I can do everything as the superuser.

I got through the "configure", then the "gmake" with no apparant problems, so I ran the regression tests and viewed the files it named at the end of the tests. Everything said "ok".

So I next did this..
initdb --pgdata=/usr/local/pgsql --pglib=/usr/local/pgsql/lib

[download]

It said it created the directories /usr/local/pgsql/data and /usr/local/pgsql/data/base. Then it said it was creating template database and threw this error..
ERROR: Error: unknown type 'oidvector'.<br>
ERROR: Error: unknown type 'oidvector'.<br>
syntax error 12 : parse errorinitdb: could not create
template database initdb: cleaning up by wiping out 
/usr/local/pgsql/data/base/template1

[download]


To say the least, I am puzzled. Any help would be greatly appreciated.

Roy Alan

Replies are listed 'Best First'.
RE: The elephant is stomping me...
by johannz (Hermit) on Aug 10, 2000 at 23:39 UTC

    Since it's been an issue lately,
    I'm '--' this post for a few reasons:

    1. Off-topic for PerlMonks
    2. The subject line does not convey that this is a non-perl question. I usually look in newest node for questions to answer I went to this node with no idea what I'd find there.

    In the future, if you are going to post off-topic questions, I would ask that you indicate that in the topic line. I'm not going to go into whether off-topic posts should be allowed; I'll leave that up to individual users to decide if they want to read off-topic posts.

    Royalanjr, thank you for your time in reading this. This was written in the spirit of helping improving everyone's experience here and I do appreciate your participation in the site.

[reply]
      True, this is not strictly a perl question. But I know that there are probably more than a few people on here that use PostgreSQL and perhaps one of them have an answer.
      Your advice on marking a post as off-topic will be taken.

      Roy Alan

[reply]
(jjhorner)The elephant is stomping me...
by jjhorner (Hermit) on Aug 10, 2000 at 23:54 UTC

    kudra is a PGSQL person, so ask her.

    I personally don't mind this question, as it is technical in nature and isn't too annoying.

    When PGSQL died out, is it still running? If the template db didn't get created, does it stop you from creating real dbs and use them? 

    J. J. Horner
Linux, Perl, Apache, Stronghold, Unix
jhorner@knoxlug.org http://www.knoxlug.org/
[reply]
Would you believe..?
by royalanjr (Chaplain) on Aug 11, 2000 at 01:03 UTC
    Well, the answer to this problem seemed to be that an old version of PostgreSQL was slinking about the server. After I cleaned that old version off, things worked fine.
    Thanks for the responses and the time.

    Roy Alan

[reply]

Back to Seekers of Perl Wisdom