[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Multiple SQL Databases
****** 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?
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
