This is a multi-part message in MIME format.
--------------090305040909070709090700
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
That's my biggest problem.<br>
The server i have use plain format dumps , but use gz to archive them
.<br>
<br>
I could change the way backups are made but that's not my goal.<br>
<br>
So my problem remains : how can i convert Plain format dumps to files
readable by pg_restore ?<br>
<br>
<br>
<br>
Dave Page wrote:
<blockquote
cite="mid:937d27e10806190127x5ba98239o7d33be55e615b30f@[EMAIL PROTECTED]
"
type="cite">
<pre wrap="">On Thu, Jun 19, 2008 at 8:34 AM, daniel <a
class="moz-txt-link-rfc2396E"
href="mailto:daniel@[EMAIL PROTECTED]
"><daniel@[EMAIL PROTECTED]
>
wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Is there a tool to convert
postgresql backups (sql.gz files) to Pgadmin Backups ?
</pre>
</blockquote>
<pre wrap=""><!---->
With the exception of PLAIN format dumps, they are entirely compatible
because pgAdmin just calls pg_dump to create them. PLAIN format
backups must be fed into psql however - pg_restore doesn't understand
them, and that's what pgAdmin uses for restores.
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="CONTENT-TYPE" content="text/html; ">
<title>Dan Turcitu</title>
<meta name="GENERATOR" content="OpenOffice.org 2.3 (Win32)">
<meta name="CREATED" content="0;0">
<meta name="CHANGEDBY" content="a a">
<meta name="CHANGED" content="20080229;9173515">
<meta name="ProgId" content="Word.Do***ent">
<meta name="Originator" content="Microsoft Word 12">
<style type="text/css">
<!--
@[EMAIL PROTECTED]
{ size: 8.5in 11in }
P { color: #000000 }
A:link { color: #0000ff }
A:visited { color: #0000ff }
-->
</style>
<p style="margin-bottom: 0in;"><small><font
face="Courier New, monospace"><font face="Courier New,
monospace"><b>Dascar
Daniel</b><br>
Ascent
Soft SRL<br>
<font size="3"><small><a class="moz-txt-link-abbreviated"
href="http://www.ascent-soft.ro">www.ascent-soft.ro</a></small></font></font><br>
<a href="mailto:daniel@[EMAIL PROTECTED]
"><font
face="Courier New, monospace">daniel@[EMAIL PROTECTED]
></a><br>
</font></small></p>
<p style="margin-bottom: 0in;"><small><font
face="Courier New, monospace"><font size="3"><small>tel:
+40256 40.74.00<br>
fax:
+40356 40.90.47<br>
gsm:
+40722 32.67.96</small></font></font></small></p>
<p class="msonormal"><img
style="border: 0px solid ; float: left; width: 127px; height: 41px;"
alt="r" src="cid:part1.07060608.05090706@[EMAIL PROTECTED]
"
name="graphics1"><br clear="left">
<br>
<br>
</p>
</div>
</body>
</html>
--------------090305040909070709090700
Content-Type: image/jpeg;
name="graphics1"
Content-Transfer-Encoding: base64
Content-ID: <part1.07060608.05090706@[EMAIL PROTECTED]
>
Content-Disposition: inline;
filename="graphics1"
/9j/4AAQSkZJRgABAQEAYABgAAD/4QByRXhpZgAASUkqAAgAAAACAABRBAARAAAAJgAAAAFR
AwABAAAAAAAAAAAAAAAAAAAAAAAAAMgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkAAAA
ZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZAAAAP/bAEMACAYGBwYFCAcHBwkJCAoMFA0MCwsM
GRITDxQdGh8eHRocHCAkLicgIiwjHBwoNyksMDE0NDQfJzk9ODI8LjM0Mv/bAEMBCQkJDAsM
GA0NGDIhHCEyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIy
MjIyMv/AABEIAEsA3AMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJ
Cgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR
8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2
d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX
2Nna4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJ
Cgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS
8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1
dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV
1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/2gAMAwEAAhEDEQA/APf6KKKACisTxXJqlvoM11pE
/l3MH7wrsDb0HUcj8fwryz/hYnib/n/T/vwn+Fb06EqivFkuSR7dRXiP/Cw/E3/P+n/fhP8A
Crel/EfWo9Tt21C5WWz34lURKp2njOQM8dfwq3hKiQvaI9jorgfG+va3pP2a+0u9UWMw2Mvl
I21+oOSOhH8q4/8A4WH4m/5/0/78J/hUww05x5k0Dmk7Ht1FeI/8LD8Tf8/6f9+E/wAK1dF8
SeMdbnCxX8cUAPzzPbpgfTjk+1OWFnFXbQKaZ6zRXkut+NvEGkazc2MV7HMkRXDyQLk5UHnA
A71oWmseOL21iuIZ7Hy5VDLlVBwal4eSSba1HzHpVFcY154p/wCEceTzrcapC7NtSMMsyeg9
D1/KuRsPiVrKahAb+SJ7UOPNVYQG298URoSknytaA5JbnsNFcf4l8ZpZ2kFvo7Lc6ld7TCqD
cFU/xH69vz7UzU9V1rSPCE15PexPqKlCdsQ2JlgCo9evWoVKTt5j5kdnRXkWmeNfFmrXf2a2
ntfM2lvniAGBT9U8Y+LtGuEhu5bXc67l2xAgjpWn1aV+W6uTzrc9aorzy68bahL4Hi1a3MUN
4s4ikGzcrdRwD07GsfSvGPi3WLh4bWe03ou474wOM4/rSWHk032Hzo9borh9KvvF41OA6k9m
9nuIlEYAbGDgj8cVzuuePNe0/XL21guIfJilZUzCCQO1KNCUnaLQOVj1qivMX13xtHppvzNZ
GEReacIuduM9KXwp8QNSv9bistSEMkUwIV0TaVYDP4jin9XlZtNOwcyPTaK871bVfGthFdXv
mWSWiFmUbVLBM8fjjFYen+OfFWp3qWlvPa+a+SN0QA4GaFh5NXTQc6PYKK5rw3fa43nprht2
bKmJoce+Qf0rpAcjNYyVnYpC0UUUgGuodSp715t4ovNL0LU/s0+j5DqHR0jTaw/+sa9LrmfE
mkaZ4msd0k4YWjtmWFwShA+ZSefbI9hWlJpS97YUttDz7/hJtE/6BLf9+0o/4SbQ8/8AIIb/
AL9pTW0Tw0DxrAI/67L/AIUn9ieG/wDoLj/v8v8AhXZal2f4mfvHaeHNX03xJYzWqW4XycDy
JlBGOxA6Y4rk7zX9Ntb2a2l0MJLE5RlwvBB+lWdFi0LRtSW7g1pQwBUhplwwPY8fT8q66fw/
Y3OpDWEhV7l0XD9V46MB64xz7Vi+SEno7FatGVpWkx6jbCeXSY7UN91JFUsR6kY4retNEEO1
VUKg6KowBWhY2roMua0gMCueUrlJHhHjZBH4w1BB2ZP/AEBa2tGl8UDT7cWUVi0IjGzzOuO2
eetQ+MdB1a78UX95FYSmCRxsbI5AUDPX2qbTLzxJZWsVvDo0cixqFBY8/wA675NOnFKz9TNb
s7vw8LyTTk/tQILzc24JjGM8Yx7V5v8AEDT7Gw1/NpKvmzDfNCv8Dev4+n4966yHV/EUejTS
f2SP7ReQrCiY2xrgfM2Tyc54qPRPDKW1pLLqA+06jeKftDSc7Qeq/wCJrCnL2UnN/cimr6HJ
+Br21tNXaOaNRPMNsMp/hPdfx/8ArV3PjKDZ4JvZCeSY/wD0Na8/1PwnqljqMqW9tK8KvmKU
EDjqPxH9K6+4uNV1nwJcWM9jKb/KLjj95hgd3X0HNaVVF1I1E+xKvZo4Pw/eTWOp+dBaSXT7
CPLTOccc8A1oeIH1XXLmGY6LdW6xpsA8tmzznOcCrPhrRtRsNbVrq0kjQoVyccHivToNNMsI
yaKtaMKl0rhGN0eYXVpPY+A/JnXY5nDlfTJrM8NtqSX0h0xYWl8v5vN6YyK9G8Z6Hcz+HvIs
bd55mmUkLjgDJzzXCaVY67o128kWml3ZdpVyMdfY1VOpzU3e12DVmdnoz+JG1OAalHaLZYbe
YsZzjjv64rz/AMVY/wCEo1LHTzjXc6bqXiWa+torjSYILdpB5kvUhe/8Vcx4j0DVbnXr66is
ZTDJMxRsjkevWlRajNuVlp0CWq0Ir3VtbstJitrgQrbXMOxCFySuB+Rwaj8JWE0+rRXaMojg
b5ueeQccV1N5oU2q+EUiSI/a4UR0Q9dwGCPyzWH4b0/VtI1uNprKUQv8koyOB2PXsf601Ui6
UrWTCzuju/EkW7wXqDt1EP8AUV5h4U/5GO2+j/8AoJr1zxBBLd+Eb23tYWlmkj2oi9ScivMN
G0PVtP1mKSazeLAYbjghSVIH61nQklSkm/6sOS95Hrmn2qmJW71pgYGK4nw4txDegssg+cls
oVwnzcMSPmOSh79D757VW3LmuWUbOxoh1FZus6xFo1p5rQTzyNkRxQoWLH8Og9zXlmra74j1
O7Mzi9tkHCRQq6Ko/Dqfc1y1sRGlpuzuwmAniNb2XdnceK4fE1+jWumNb2toRh5DKRJJ7cD5
R+tYng3TdV8P3c8FwYXtJhkqjk7XHfp3HH5VyJu9dPW41I/V5Kb5+tZyJdQz65eo/tR8nJya
HZ/Ymt/aI2db8B3Y1Oeaxe3W0kbciMxBXPUcDpnpWX/whWp/89Lb/vpv/ia7O9lu/EfgwSwN
cW+pW43FULIXZRy****yPfFeeGfXR1k1IfUyV7OHqzqwUlJHh1afs5uElqjQ/4QrU/wDnpbf9
9N/8TXo3g4X1npcdjftG7RHbGyEn5OwOQOnT8q8p+0a5/wA9dR/N6v6Nq+taZq1vdSfb5okb
95G4dgyng8Hv3FXVpznGzaITSZ67r/iG08O2ST3CPI0jbUjTGSfx7Vj2njiW+h8620WeSPOM
+eg5/E1W8a/YNT0uyM880PzFo5UhMg6DIIHPP9K8/n0+0jjdor9pXA+VPszru/E9K+exFarC
o0tvl+p9BgsJh6tFOSfM/Jtfhb8z1JdZW7tbq41CwmsordN5ZmVww5zjb39veufsvFkN9cGG
x0e6mcDdgOoOPWud0G2vG07VY0jkCTQbVUjAZuox/nvUfhu8Gk6nJJdJLGrRlM+WTg5B6de1
T9ZqPku7JmrwFCKq2XM42slft63/ABOpfxpbWV4ba90y6gdSN4LAlQe+O9ZfjfU7r7VBBCJo
LfaWVw+BMDjB47D3rG8QSnVdclntIppEcKqkxkE4GOlXfFSysumxlWZo4NpwM46f4VnUq1Jw
mr6I3oYajSq0pKNm07rtoWNFtxeW1v5tpqEjNkm4F1hTjOPlz9BVXUfEusW2pTRRO9oqsMQl
VJXgd8f5zXUeDofM0q2BGCAQQfqa5Xxhp91b+JrqRreTynZWR9pww2jv+FOrGVOhGUHvb8iM
NUhWxk4VIp2va+vXzOyg1O4m8yWTRLhBHG0m4yLyQM447mpNB8dWuq6lFYJZyQmQEh2cEcDN
RaHrVheTxWkbTNLLkYMTADjJySMVwV5b3Og+IZhAjBraYmM4OCvb9DW1WtKHLKMrq+uxy4bC
U63PCpDllbTf9X3O71D4i2ltdT2/9nzSJHI0YkDgBsHBIqSbWbNtL0/UIbZ5WvZRCkQYAqxy
OfxFcpqemMPCNi4RmmhYvJxz8/X9dtR+FjcTalaxSg+RZl5lBH8TYH/16lV6yqckutrGssJh
XRdWC+Fu+u9r/nodze3N1aXbQ2+jXNyigHzUdVUnHQZrN1LxM2nxI19od1CjnapMqnJ/CuS8
UC+PiG4eYXHlkgoecbcDp2pNZj0yWyifS4Lgur4kZg5AGOmW4z9KU8TO8uV2t6f5Do4Cjanz
q/Mul/xfN+h3lr4jsP8AhGp9Yt4JHWEhZISQGByB/XNY6eNrC6LsmmXTTAjbGmGJHc+2OPzr
C01nTwZqkWG+aQfLjn+Gn+C/Mi1C4G1lLIByMd6ar1ZShFO11/mTLB4enTqzcb8r016af5nY
r4ytLXQTfXNlcQkzGFIG+8xxnPPQVQg8SnUoXu7fQrqWJCQzLIvBAzUfjjTrubRbeWKJ5RHL
l9oyQCCM4rltHlhhtmiudQ1C0yx+SHdtPvwDzTqVqkavI3pbyJoYXD1MP7VR1vtq7fdqdx4f
8W2GsXwslt5YJSpZNxBDY6jiuwUAKMV5boNlpcWtRPp9xdSTKrHDxlQBjHcD1r0y3LGFc9a6
cPKcoXm7vyODHU6UKtqSaVuv/BJ3BZSBWXPpjTMSSa1qK3OIwv7DFH9hit2igDMttN8imXGk
rK+4VrUUAYf9iCgaIAa3KKAKMNmY4tmarvpm5ia1qKAMePSAH3Gll0kMwIrXooAyH01nXaTx
UiaYFiK1p0UAZtpp/wBnk3VPeWYuVwat0UAZUGntCflPFPudP89eetaVFAGZb6YsSEGojpA8
7fWxRQBnz6eJIgtQJpZRdo6Vr0UAZEWlbH3Up0v98HrWooAhMIMOw1mnSQJSwrYooAzVsSCK
vIm1AKkooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo
oAKKKKACiiigD//Z
--------------090305040909070709090700--


|