Skip site navigation (1) Skip section navigation (2)

CHANGING THE DATA LOCATION

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: CHANGING THE DATA LOCATION
Date: 2009-02-16 18:27:10
Message-ID: f03943a00902161027y1907a330t324525088b927212@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I am building a web site with Visual Studio 2005 and I already have my
database files in a tablespace that points to  c:\e_restdelivery\App_Data.

Now, I am chainging to Visual Studio 2008 and I have a new folder structure
for the database which is c:\Visual Studio 2008
Projects\e_restdelivery\App_Data.

In order to take my database to the new location I suppose I need to create
another tablespace, a new schema and a new database. Can I keep the same
name for the tablespace, schema and database?
Please advice if this can be achieved and how.

With respect,
Jorge Maldonado

pgsql-novice by date

Next:From: Isabella GhiureaDate: 2009-02-19 22:19:15
Subject: psqlsrc file
Previous:From: Andreas WenkDate: 2009-02-12 15:27:29
Subject: Re: Exporting tables/views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group