subscribe for a digest fails

From: sarlav kumar <sarlavk(at)yahoo(dot)com>
To: "Vishal Kashyap (at) [SaiHertz]" <vishalonlist(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: subscribe for a digest fails
Date: 2004-11-17 16:50:20
Message-ID: 20041117165020.43291.qmail@web51310.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

Thanks again.

I would like to subscribe for a message digest. I tried sending a mail to pgsql-novice-request(at)postgresql(dot)org with a single line in the body of the message:
subscribe-digest

But I get a mail saying that the command was not successful.
Any idea how I can subscribe for a digest??

Thanks,
Saranya

"Vishal Kashyap @ [SaiHertz]" <vishalonlist(at)gmail(dot)com> wrote:
Sarlav ,

>
> I am new to postgres.

Welcome to the most powerfull Database system.

> I am looking to upgrade to 7.4.x. Is the upgrade necessary?
>
Your upgrade to 7.4.x would be worth in many terms as 7.4. has many
performance enhancements also if your app uses subquery then 7.4 is advisable.

>If so, which is
> the most stable version to upgrade to?

7.4.5

>
>
>
> We have more than 300 tables with lot of data to be backed up and restored.
> It would be nice if someone could give the steps to upgrade from 7.3.2 to
> one of the latest stable version.

1. Backup everything make a file system bacup of the PostgreSQL
database (plz make sutre to shut down PostgreSQL before doing this)
2. Backup data.
3. Backup Schema
4. Install 7.4.5 give database path diffrent
5. Initdb the database (This is required as you are upgrading to a
major version)
6. Restore schema in new system
7. Restore database
8. Run PostgreSQL make sure you append the $PGDATA

Now you are on PostgreSQL 7.4.5
If something goes wrong.
Reinstall PostgreSQL 7.3.2
Restore your filesyatem backup.

Hope this helps

--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com,
http://vishalkashyap.tk

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly


---------------------------------
Do you Yahoo!?
Discover all thats new in My Yahoo!

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Roberto Rezende de Assis 2004-11-17 17:32:32 Question on index
Previous Message Tom Lane 2004-11-17 15:27:21 Re: Previous month function