[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Multiple SQL Databases
****** message to minivend-users from kswisher@iolinc.net (Swisher, Karl) ******
On Mon, 03 Apr 2000, you wrote:
> ****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
>
> On Mon, 3 Apr 2000, Swisher, Karl wrote:
> > After reading in the archieve I'm a little confused. I have been using
> > Postgres. It has been working to my satisfaction so far. I've created the
> > tables outside the Minivend environment. Two of the tables I'm using have a
> > serial field and I have had no problems writing and reading data to/from them in
> > Minivend.
> >
> > Now I want to do something a little different. which I think I should
> > be able to do but haven't had success yet. I want to split the database into
> > two databases with some of the tables in one and the rest in another. I
> > created two new databases using psql and then copied my existing database
> > into each of these. Then I used drop for the tables I didn't want in each
> > and edited the catalog.cfg to reflect this. A restart of Minivend shows no
> > errors. The catalog compiles in just fine. However Minivend can only find the
> > first database. If it tries to access a table in the second database it errors
> > out with a "can't find table" in the error.log. I have verified the data in
> > both databases with psql. The tables and data are there.
>
> Did you update your catalog.cfg and change the Database directives to
> point to the two new DB's?
Yes, When I restarted Minivend and there were no errors I though I had it.
But when I tested it in the browser it failed.
Thanks
Karl
> Dan
> --
> Dan Busarow 949 443 4172
> Dana Point Communications, Inc. dan@dpcsys.com
> Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
