Обсуждение: A question

Поиск
Список
Период
Сортировка

A question

От
Biso Dimitrov
Дата:
Hi, i don't wheather I should ask you here, so excuse me.
First of all , GREAT JOB!!! pgAdminII is a great aplication, that gives me much power than the usual prompt.

My question is here: I am making a simple database, I want a friend of mine to  use it. The problem is that he is not
connectedto my computer. What should I do? How I should "export" the database. Should I consider making it from
superuser,or from any other user. 

And one more question, I don't know if my friend is using Windows or Linux, is this going to make a difference?
Than you for your time, looking forward to hearing from you.
Kind regards,
Biser

Re: A question

От
"Dave Page"
Дата:

> -----Original Message-----
> From: Biso Dimitrov [mailto:pent@abv.bg]
> Sent: 19 May 2003 11:37
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] A question
>
>
>  Hi, i don't wheather I should ask you here, so excuse me.
> First of all , GREAT JOB!!! pgAdminII is a great aplication,
> that gives me much power than the usual prompt.

Thanks, glad you like it!

To be honest this isn't really the place for this question
(pgsql-general@postgresql.org would be), but I'll make a suggestion.

> My question is here: I am making a simple database, I want a
> friend of mine to  use it. The problem is that he is not
> connected to my computer. What should I do? How I should
> "export" the database. Should I consider making it from
> superuser, or from any other user.

The easiest thing is for you to run pg_dump to export the database, and
for him to load it on his PostgreSQL system. Look in the PostgreSQL
manual in the pgAdmin helpfile for info on pg_dump.

> And one more question, I don't know if my friend is using
> Windows or Linux, is this going to make a difference?

Not as long as you both run the same version of PostgreSQL.

Regards, Dave.