From: Dianne Yumul <dianne@wellsgaming.com>
To: pgsql-admin@postgresql.org
Cc: Muhammad Farid <farid13@gmail.com>
Subject: Re: backup
Date: Thu, 15 Dec 2005 08:52:42 -0800
Message-ID: <36cbf801a4622fe3a39da70efdd96146@wellsgaming.com> (raw)
In-Reply-To: <1134653856.14515.2.camel@pgbuildfarm.gunduz.org>
References: <4a9605050512141700m4b7c9fbbn957aa286cf347323@mail.gmail.com>
<1134653856.14515.2.camel@pgbuildfarm.gunduz.org>
>> database itself using command pgsql < db name > .
It should be psql <db_name> (not pgsql), at least on versions greater
than 7.3. And I agree, postgresql 7.2.2 is pretty outdated.
hope this helps.
On Dec 15, 2005, at 5:37 AM, Devrim GUNDUZ wrote:
> Hi,
>
> On Thu, 2005-12-15 at 09:00 +0800, Muhammad Farid wrote:
>
>> I have installed Suse Linux Opeb Excchange server and its running
>> using postgresql-7.2.2-35. And my problem here is i cant log in to the
>> database itself using command pgsql < db name > .
>
> What kind of an error message you get?
>
>> And also please teach me what is the command to manually backup the
>> database in postgresql ?
>
> Use pg_dump.
>
> BTW... Your PostgreSQL version is outdated and is not supported by
> community (I'm not sure whether SuSE supports it or not). You should
> update to a newer version.
>
> Regards,
> --
> The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dianne@wellsgaming.com, farid13@gmail.com
Subject: Re: backup
In-Reply-To: <36cbf801a4622fe3a39da70efdd96146@wellsgaming.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox