Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
'export PGDATA2' 4 use of secondary data location fails
Phew, I thought I was getting worried, not being able to do what others could. A solution I came up with in the end is to define de PGDATA2 variable in /etc/profile. This gets the variable set for *all* environments and did the trick for me. The question remains however why defining PGDATA2 in...- Rarch
- Post #10
- Forum: PostgreSQL Inc.: PostgreSQL
-
'export PGDATA2' 4 use of secondary data location fails
I´m sorry to say that it doesn´t work on my box,..... and don´t know why. Let me outline what I did: As I´ve pointed out before (but not explicitly), RedHat 7.2 with PostgreSQL7.1.3 installed from RPM´s, none modified. Login as regular user. su to root. passwd postgres. login as user...- Rarch
- Post #5
- Forum: PostgreSQL Inc.: PostgreSQL
-
'export PGDATA2' 4 use of secondary data location fails
Thank you for the reply. I take it that with "log in to postgres" (to edit the environment variables in /var/lib/pgsql/.bash_profile) you mean to edit that file as linux user "postgres" (ie. do "su postgres" as root). If not, how do I log into postgres?- Rarch
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
'export PGDATA2' 4 use of secondary data location fails
How do I set the PGDATA2 variable for the (RedHat 7.2) postgres user (no /home/postgres installed: /etc/password references /var/lib/pgsql) to be able to do a "createdb -U rarch -D 'PGDATA2' databasename"? My efforts to su to postgres and do an "export...- Rarch
- Thread
- Replies: 9
- Forum: PostgreSQL Inc.: PostgreSQL
