 | |
#1
 
| |||
| |||
|
Change datadir -
05-24-2008
, 01:06 AM
#2
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#3
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#4
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#5
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#6
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#7
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#8
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#9
| |||
| |||
|
|
Hello, I have a newly installed postgresql-8.3 on a debian 4.0 machine. I installed it from backports.org. What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. |
data_directory - value in your postgresql.conf to the new value, start
the server.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
#10
| |||
| |||
|
|
Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote: What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. Stop the database, move the datadir to the new destination, change the data_directory - value in your postgresql.conf to the new value, start the server. |
work. On the Debian installation of the production server, I install yet,
it works perfect.
Thx
Andreas
--
Kraftl EDV - Dienstleistungen
Linuxschulungen, Weblösungen, Linuxlösungen
http://www.kraftl.at
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.