In vw7.8, following PostgreSQL Setup on page 3.5 of the SourceCodeMgmtGuide.pdf to create a new Store repository, when I try to connect to the repository with a normal user created via #> createuser -U postgres -D -A -P <username>, I keep getting the error:
'The Store database tables do not appear to be in the current database. Install Store database tables?' The tables are clearly there when the new database is viewed with pgAdmin3, and the repository is usable if a user is a superuser. I do not want to create all repository users as superusers. The symptoms are the same from client images running on both Mac and Linux. The server where the new repository is being created is running Ubuntu 12.04 LTS (GNU/Linux 3.2.0-27-generic x86_64), and PostgreSQL 9.1. Does anyone know how to get around this issue? Thx for any tips. Ken G. Brown _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Dear Ken,
you apply the appropriate resolution (100490 IIRC). I'll email you. (This will be restored in 7.9.1.) Yours faithfully Niall Ross >In vw7.8, following PostgreSQL Setup on page 3.5 of the SourceCodeMgmtGuide.pdf to create a new Store repository, when I try to connect to the repository with a normal user created via #> createuser -U postgres -D -A -P <username>, I keep getting the error: >'The Store database tables do not appear to be in the current database. Install Store database tables?' > >The tables are clearly there when the new database is viewed with pgAdmin3, and the repository is usable if a user is a superuser. > >I do not want to create all repository users as superusers. > > No indeed. >The symptoms are the same from client images running on both Mac and Linux. >The server where the new repository is being created is running Ubuntu 12.04 LTS (GNU/Linux 3.2.0-27-generic x86_64), and PostgreSQL 9.1. > >Does anyone know how to get around this issue? > >Thx for any tips. >Ken G. Brown >_______________________________________________ >vwnc mailing list >[hidden email] >http://lists.cs.uiuc.edu/mailman/listinfo/vwnc > > > > _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Thank you very much for the quick response.
I had a quick look and it seems there was a lot to correct. Thx, Ken On 2012-07-27, at 4:40 PM, Niall Ross wrote: > Dear Ken, > you apply the appropriate resolution (100490 IIRC). I'll email you. > > (This will be restored in 7.9.1.) > > Yours faithfully > Niall Ross > >> In vw7.8, following PostgreSQL Setup on page 3.5 of the SourceCodeMgmtGuide.pdf to create a new Store repository, when I try to connect to the repository with a normal user created via #> createuser -U postgres -D -A -P <username>, I keep getting the error: >> 'The Store database tables do not appear to be in the current database. Install Store database tables?' >> >> The tables are clearly there when the new database is viewed with pgAdmin3, and the repository is usable if a user is a superuser. >> >> I do not want to create all repository users as superusers. >> > No indeed. > >> The symptoms are the same from client images running on both Mac and Linux. >> The server where the new repository is being created is running Ubuntu 12.04 LTS (GNU/Linux 3.2.0-27-generic x86_64), and PostgreSQL 9.1. >> >> Does anyone know how to get around this issue? >> >> Thx for any tips. >> Ken G. Brown >> _______________________________________________ >> vwnc mailing list >> [hidden email] >> http://lists.cs.uiuc.edu/mailman/listinfo/vwnc >> >> >> > > _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Free forum by Nabble | Edit this page |