Обсуждение: Re: problem after restoring a backup database on a different

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

Re: problem after restoring a backup database on a different

От
mail TechEvolution
Дата:
Hi Scott

i don't know, i do just the exact thing, with exact users and one the
other pc (where the db is not original created, + tried on 3 different
pc) it is not working.

i can restore the database, the tables and data is there, but i cannot
use the tables

i can connect to the database itself, but when i try to run an easy sql
statement as select * from table, i recieve:

relation "table" does not exist

if it had to do with the user, i wouldn't be able to restore the
database, right?

do you think it has to do with the schema?  (wich i do not know what you
mean by this, i ame a novice to PostGreSQL) if so, can you help me what
i can do to check this?

greetZ

wes

Scott Ribe schreef:

>>do you have any idea what i do wrong or what can be going wrong?
>>
>>
>
>Something to do with difference re database user or schema???
>
>
>


Re: problem after restoring a backup database on a

От
Scott Marlowe
Дата:
Not sure, could you post a cut-n-paste of your session so we can see
what you're doing?  Sometimes just having someone to "look over your
shoulder" makes all the difference in the world.

On Fri, 2005-07-15 at 12:41, mail TechEvolution wrote:
> Hi Scott
>
> i don't know, i do just the exact thing, with exact users and one the
> other pc (where the db is not original created, + tried on 3 different
> pc) it is not working.
>
> i can restore the database, the tables and data is there, but i cannot
> use the tables
>
> i can connect to the database itself, but when i try to run an easy sql
> statement as select * from table, i recieve:
>
> relation "table" does not exist
>
> if it had to do with the user, i wouldn't be able to restore the
> database, right?
>
> do you think it has to do with the schema?  (wich i do not know what you
> mean by this, i ame a novice to PostGreSQL) if so, can you help me what
> i can do to check this?
>
> greetZ
>
> wes
>
> Scott Ribe schreef:
>
> >>do you have any idea what i do wrong or what can be going wrong?
> >>
> >>
> >
> >Something to do with difference re database user or schema???
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq