On Dec 7, 2007 2:18 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
> Hello-
>
> I'm trying to do an upgrade of version 8.1 to 8.2.3. The restore is
> failing because of some code that is in some views. If I dump the
> just the schema and then dump just the data, will the views be included?
Well, th
Hello-
I'm trying to do an upgrade of version 8.1 to 8.2.3. The restore is
failing because of some code that is in some views. If I dump the
just the schema and then dump just the data, will the views be included?
Carol
---(end of broadcast)---
Hello,Simply looking from the point of recovering the deleted files, why not try something like http://recover.sourceforge.net/linux/ ?Obviously you Postgres error may have to be solved separately.Regards,-ThusithaSrinivas Iyyer <[EMAIL PROTECTED]> wrote: Dear Group, Please help me if you can. I am
Dear Group,
Please help me if you can. I am in a the most gravest
situation. here
I read the bug report :
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208
reason:
I got error when i tried \dt
relation "pg_catalog.pg_user" does not exist.
After reading some responses Comment#21 and
*** Apologies for re-posting this e-mail
Dear group,
I have a strange problem. apologies if this is the
wrong place, however as a first option i am posting
here. I have to subscribe to other special mailing
lists.
I have two databases in my system.
In firstdb i am having the following p
"Andrei Bintintan" <[EMAIL PROTECTED]> writes:
> If I create a table with create table and after that I modify the =
> table(add some columns) in the dump the table is saved in the same way, =
> I mean, in the dump first the table is created and after that the column =
> is added.=20
I don't actua
Hi to all,
If I create a table with create table and after
that I modify the table(add some columns) in the dump the table is saved in the
same way, I mean, in the dump first the table is created and after that the
column is added.
Is there a possibility to dump the database and the
ta
Hi,
I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.
Are there any reasons not to simply just copy the entire data directory
over to the test system? I could not find any p
> I need to set up a daily cron job that performs a pg_dump on a remote
> database. I can't figure out how to pass a password to it. How do I do
> this. Everything I've tried still comes up with asking me for a password
> when I test it.
>
$ export PGPASSWORD=user_pass
$ echo -e "Would do the tr
One way is to do this is by configuring the remote server to trust the host
that is going to be doing the back up. This can be done in the pg_hba.conf
file which is located in "/var/lib/pgsql/data" on my server.
If the Server that is going to be doing the back up has the IP address of say
192.16
Hi Folks,
Fairly basic question here, I think. I've looked through the archives, but
can't seem to find anything.
I need to set up a daily cron job that performs a pg_dump on a remote
database. I can't figure out how to pass a password to it. How do I do
this. Everything I've tried still comes up
Hello..
I have password authentication going on my DB, and everything works
quite well except for this command:
pg_dump -u > dumpfile
it just hangs but when I run pg_dump -u it will print all
the stuff out to me, so I assume it must be with putting it into a
file. Does anyone have any sug
12 matches
Mail list logo
