<?xml version='1.0' encoding='windows-1251' ?><feed version="0.3" xmlns="http://purl.org/atom/ns#" xmlns:dc="http://purl.org/dc/elements/1.1/"><copyright mode="escaped" type="text/html">Copyright 2005, QAIX.com</copyright><generator>QAIX / QAIX.com</generator><link href="http://zoukou.qaix.com" rel="alternate" type="text/html" /><modified>2007-02-27 12:37:07</modified><title mode="escaped" type="text/html">developper</title><tagline mode="escaped" type="text/html">Postgresql</tagline><entry><id>tag:zoukou.qaix.com,2007-02-27:/0-124-restauration-postgresql-database.zhtml</id><author><name>zoukou</name><url>http://qaix.com/users/zoukou/</url></author><content mode="escaped" type="text/html">Salut tout le monde,&lt;br&gt;j'ai un probl&amp;amp;#232;me avec la restauration de la base de donn&amp;amp;#233;e?&lt;br&gt;j'utilise la commande : pg_dumpall --clean -h localhost -U databaseuser &amp;gt;savefile&lt;br&gt;mais je fais la restauration sur une autre machine version 7.4.6:&lt;br&gt;avec cette commande : psql - -h localhost -U databaseuser -d template1 -f savefile&lt;br&gt;&lt;br&gt;&lt;br&gt;et j'ai cette message d'erreur lors du l'ouverture du PGAdminIII :&lt;br&gt;&amp;quot;la relation pg_user n'existe pas &amp;quot; et &amp;quot; la relation pg_settings n'existe pas&amp;quot;&lt;br&gt;&lt;br&gt;et aussi quand j'utilise cette commande : psql -l&lt;br&gt;quelque peux m'aider? &lt;br&gt;merci&lt;br&gt;&lt;br&gt;Hi&lt;br&gt;I need to restore the Database on another server using postgresql 7.4.6&lt;br&gt;to dump the database I'm using : pg_dumpall --clean -h localhost -U databaseuser &amp;gt;savefile&lt;br&gt;to restore the database to another server I try this command:&lt;br&gt;psql - -h localhost -U databaseuser -d template1 -f savefile&lt;br&gt;and I have this message : can't find pg_settings, can't find pg_user&lt;br&gt;even when I use thi command : psql -l&lt;br&gt;thanks for advance&lt;br&gt;best regards&lt;br&gt;&lt;br&gt;[&lt;a href=&quot;http://zoukou.qaix.com/0-124-restauration-postgresql-database.zhtml#add&quot;&gt;Add comment to QAIX.com&lt;/a&gt;]   [&lt;a href=&quot;http://qaix.com/p/register.cgi&quot;&gt;Start blog at QAIX.com&lt;/a&gt;]</content><dc:subject>zoukou</dc:subject><issued>2007-02-27T12:46:06-00:00</issued><link rel="alternate" href="http://zoukou.qaix.com/0-124-restauration-postgresql-database.zhtml" type="text/html"/><modified>2007-02-27T12:46:06-00:00</modified><title mode="escaped" type="text/html">restauration postgresql database</title></entry></feed>