Making PostgreSQL create directory for new tablespace

Question

i would like to be able to do something like

CREATE TABLESPACE bob location 'C:\a\b\c\d\e\f\bob'

without needing to create all the directory tree beforehand. this is because i have java code that creates tablespaces on the fly and i would like to be able to run it on a separate machine (so it couldnt mkdir() or anything).

is there any sort of postgres configuration that would allow me to make postgres create the appropriate directory tree by itself?

Konstantin V. Salikhov · Accepted Answer · 2012-12-25 10:44:51Z

1

You could try do mkdir directly in postgres stored procedure using PL/sh or any of your favorite PL/* languages that are available for PostgreSQL

answered Dec 25, 2012 at 10:44

Konstantin V. Salikhov

4,6512 gold badges38 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

radai Over a year ago

could you please point me to info on how i can do this using the built-in pl/pgsql ? i cant install any extensions on the db unfortunately, and the posgres docs for pl/pgsql only talk about dealing with tables

Konstantin V. Salikhov Over a year ago

I believe that PL/pgSQL is for data manipulation only. You could try to write your function in C (postgresql.org/docs/9.1/static/xfunc-c.html) - it needs no extensions and directly supported by postgresql

Craig Ringer Over a year ago

You can't do it in pl/pgsql but you can with pm/perlu or pl/pythonu, both of which preinstalled.

Collectives™ on Stack Overflow

Making PostgreSQL create directory for new tablespace

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related