Storing Postgres Database on External Hard Drive through Sqlalchemy

Question

I am new to Postgresql, and look for some help. My question is that I want to save the data/tables into another remote hard drive to which my machines connect but the solutions from here, here, or here only discuss how to do this process through Postgresql directly, and I am wondering whether this can be done through sqlalchemy. Can anyone help? Thanks so much.

Below are the codes I use to create the database:

database = "foo"
engine = sqlalchemy.create_engine("postgres://postgres@/postgres")
conn = engine.connect()
conn.execute("commit")
conn.execute("drop database " + database)
conn.close()

You can't, and not only that, do not put a tablespace on external removable storage. It is *useless* without the information in the main data directory; you cannot just attach it to another database. — Craig Ringer, Aug 16 '17 at 13:03

score 0 · Accepted Answer · answered Aug 17 '17 at 11:12

0

You can't and shouldn't want to. Connecting to a Postgres database means that you leave the database to decide where data is stored. In the database you can define where to store data.

answered Aug 17 '17 at 11:12

Dick Kniep

518
4
11

Storing Postgres Database on External Hard Drive through Sqlalchemy

1 Answers1