Re: managing tablespaces like files?

On 3/9/2010 12:07 AM, Sam Carleton wrote:
> I would like to thank both John and Scott for the help. It is very
> clear to me that PostgreSQL isn't the ideal solution for my current
> model. The conversation has gotten me thinking of ways the model
> could be modified to work with PostgrSQL (and other client/server
> RDBM). Thus I will return to the drawing board just to double check
> to see if there might be a better model.
>
> Thank you all, this has been truly valuable!
>
> Sam

Hello Sam:

I've had similar conversation with Application developers who are used
to working with Access databases aka file based databases. When it comes
time to backup or move the databases to other computer or share the
database over a file-share they look at databases as just files to be
copied around from machine to machine. No database server like oracle,
postgresql, mssql, mysql, or db2 allow simple copying of the database to
another location/server having it start right up. None are going to work
that way.

These databases expressly deny direct access to the files and make the
assumption their the only process accessing the files. Another problem
you may run into and need to think about is Anti-virus apps have a
tendency to create all kinds of problems with database servers.

The application can work and make the user life even easier. The
approach has to be different on how the backup restore and moving the
databases around is going to work .

Take a look at a couple of examples how others have solved this problem

One company using postgresql, directly aimed at small companies (where
there is no IT help let money to pay for IT) wrote a very nice and easy
to use front end for there application to backup, restore and move the
application to another server. go to www.3cx.com and download there
app they have a free version check out the instruction for back and
restore. Its very easy clean interface how they backup and restore the
database.

Another company that has very nice and easy to use backup and restore
of a MySQL database is Gordano Messaging Server. www.gordano.com their
backup, recovery and moving to another server is very simply. A simple
little command line tool backups the database, user profiles, and other
system settings into a nice little file called settings.txt. They also
have gui tool that will automate the backing up of the database.

All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.

CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately.
Thank you.