Creating A Tablespace in PostgreSQL 8.0 for Windows

Поиск
Список
Период
Сортировка
От Van Ingen, Lane
Тема Creating A Tablespace in PostgreSQL 8.0 for Windows
Дата
Msg-id A3FF4275060B76459B5C08A64AE330C869DC@twmail.esncc.com
обсуждение исходный текст
Список pgsql-novice
I have created a database definition (adns); now I want to create a tablespace for its data to
reside in in directory c:\ADNS. For some reason, I can't get it to work. The directory does exist
(in Windows 2003). Tried setting up the tablespace first, then the database; that didn't work
either. What am I doing wrong? I am doing this in 'psql'.
 
Once the tablespace does set up, will I also be able to see it in Windows Explorer as a file 
under c:\ADNS ??
 
mydb=# create database adns with owner = postgres;
CREATE DATABASE
mydb=# \l+
                      List of databases
   Name    |  Owner   | Encoding  |        Description
-----------+----------+-----------+---------------------------
 adns      | postgres | SQL_ASCII |
 mydb      | postgres | SQL_ASCII |
 template0 | postgres | SQL_ASCII |
 template1 | postgres | SQL_ASCII | Default template database
(4 rows)
mydb-# \db data1
   List of tablespaces
 Name | Owner | Location
------+-------+----------
(0 rows)
mydb-# \c adns
Password:
You are now connected to database "adns".
adns-# create tablespace data1 location 'c:/ADNS'
adns-# \db data1+
   List of tablespaces
 Name | Owner | Location
------+-------+----------
(0 rows)
adns-# \db+
                 List of tablespaces
    Name    |  Owner   | Location | Access privileges
------------+----------+----------+-------------------
 pg_default | postgres |          |
 pg_global  | postgres |          |
(2 rows)
adns-#

В списке pgsql-novice по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: How to get hold of postgres sql
Следующее
От: "Van Ingen, Lane"
Дата:
Сообщение: Re: Creating A Tablespace in PostgreSQL 8.0 for Windows