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
