Search Postgresql Archives

Distributing PostGres database to various customers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



All,

I am new to PostGres 8 (using 8.2.4 windows version).  We have for several years been using iAnywhere's SQL Anywhere product with our commercial transportation software.  With ASA there are 2 files that must be distributed for the database, a filename.db and a filename.log.  When we do a new installation we normally try and preload the database with data used for lookups, some registration data and if a customer is moving from another software where we've been contracted to convert their old data to our system we preload that.  Once that is done we can distribute the database as part of the setup process.

How can we do this with PostGres?  Other than backup and restore or creating SQL scripts I haven't been able to find another method.  Some of these tables may have over a million rows in them initially if we convert old data.

Best Regards,

Michael Gould
All Coast Intermodal Services, Inc.
904-376-7030

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux