You are not logged in.

#1 2005-05-17 08:57:32

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
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, working in Romania
Registered: 2002-12-27
Posts: 2,293
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, working in Romania
Registered: 2002-12-27
Posts: 2,293
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. wink


Markku

Offline

Board footer

Powered by FluxBB