You are not logged in.
- Topics: Active | Unanswered
#1 2005-05-17 08:57:32
- rasat
- Forum Fellow
- From: Finland
- Registered: 2002-12-27
- Posts: 2,296
- Website
How to manage remote DB from local machine?
My host has provided PostgreSQL in my remote server but no tools e.g. phpPgAdmin. I am asked to do it from my local machine.
I have phpPgAdmin on my local. How to connect?
Imaginary example:
DBname: myDB
Username: myName
Pass: myPass111
Host: 1.11.111.111
2. I have not find in phpPgAdmin a feature to upload dump file. How to do from local?
Within local its:
psql myDB < dump.sql
PostgresSQL and MySQL are more or less same, aswers for MySQL will also do.
Markku
Offline
#2 2005-05-17 11:42:46
- rasat
- Forum Fellow
- From: Finland
- Registered: 2002-12-27
- Posts: 2,296
- Website
Re: How to manage remote DB from local machine?
Found the answer to the second question:
Check if connected:
1. su - postgres
2. psql -h 1.11.111.111 -d myDB -U myName -W
Markku
Offline
#3 2005-05-17 16:46:09
- neri
- Forum Fellow
- From: Victoria, Canada
- Registered: 2003-05-04
- Posts: 553
Re: How to manage remote DB from local machine?
rasat,
I never used it, just built and it worked with the wxgtk from testing:
http://aur.archlinux.org/packages.php?d … Packages=0
mybe it helps on adminstering postgres, I mean it's explicitely made for that task:)
-neri
Offline
#4 2005-05-18 05:04:56
- rasat
- Forum Fellow
- From: Finland
- Registered: 2002-12-27
- Posts: 2,296
- Website
Re: How to manage remote DB from local machine?
Its great!... more "professional" than phpPgAdmin.
When I saw it on Internet thought its for Windows only. Good you told about it...... the AUR package got my vote. 
Markku
Offline