Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7D80C64FCAD for ; Wed, 10 Dec 2008 03:44:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70275-09 for ; Wed, 10 Dec 2008 03:43:59 -0400 (AST) X-Greylist: delayed 00:16:58.972399 by SQLgrey-1.7.6 Received: from mx3.fh-giessen.de (mx3.fh-giessen.de [212.201.18.28]) by mail.postgresql.org (Postfix) with ESMTP id 7555264FC57 for ; Wed, 10 Dec 2008 03:43:59 -0400 (AST) Received: from mailserv.fh-giessen.de ([192.168.186.80]) by mx3.fh-giessen.de with esmtp (Exim 4.69) (envelope-from ) id 1LAJTF-0004vs-NR for pgsql-admin@postgresql.org; Wed, 10 Dec 2008 08:26:57 +0100 Received: from [192.168.75.221] by mailserv.fh-giessen.de with esmtps (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1LAJTF-0002Ql-Em for pgsql-admin@postgresql.org; Wed, 10 Dec 2008 08:26:57 +0100 Message-ID: <493F6F40.9060906@its.fh-giessen.de> Date: Wed, 10 Dec 2008 08:26:56 +0100 From: Michael Leshchenko Organization: Fachhochschule =?ISO-8859-15?Q?Gie=DFen-Friedberg?= User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: File system level backup with more than one cluster folders Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms000104060209070802010201" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/88 X-Sequence-Number: 30921 This is a cryptographically signed message in MIME format. --------------ms000104060209070802010201 Content-Type: multipart/mixed; boundary="------------080308090707050802030807" This is a multi-part message in MIME format. --------------080308090707050802030807 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Dear pg community I am newbie with PostgreSQL. I have separate table space for my databases, which is located in separate folder, which is different to default. I would like to carry out file system level backup. Do I need to backup only folder with my table space or all pg folders. Thank you in advance Mike Leshchenko --------------080308090707050802030807 Content-Type: text/x-vcard; charset=utf-8; name="Michael_Leshchenko.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="Michael_Leshchenko.vcf" begin:vcard fn:Michael Leshchenko n:Leshchenko;Michael org;quoted-printable:FH Gie=C3=9Fen-Friedberg;ITS adr:;;Wiesenstr. 14;Giessen;Hessen;35390;Germany email;internet:michael.leshchenko@its.fh-giessen.de tel;work:(+49)641 3091279 tel;cell:(+49)1778096776 version:2.1 end:vcard --------------080308090707050802030807-- --------------ms000104060209070802010201 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIUAjCC BCEwggMJoAMCAQICAgDHMA0GCSqGSIb3DQEBBQUAMHExCzAJBgNVBAYTAkRFMRwwGgYDVQQK ExNEZXV0c2NoZSBUZWxla29tIEFHMR8wHQYDVQQLExZULVRlbGVTZWMgVHJ1c3QgQ2VudGVy MSMwIQYDVQQDExpEZXV0c2NoZSBUZWxla29tIFJvb3QgQ0EgMjAeFw0wNjEyMTkxMDI5MDBa Fw0xOTA2MzAyMzU5MDBaMFoxCzAJBgNVBAYTAkRFMRMwEQYDVQQKEwpERk4tVmVyZWluMRAw DgYDVQQLEwdERk4tUEtJMSQwIgYDVQQDExtERk4tVmVyZWluIFBDQSBHbG9iYWwgLSBHMDEw ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDpm8NnhfkNrvWNVMOWUDU9YuluTO2U 1wBblSJ01CDrNI/W7MAxBAuZgeKmFNJSoCgjhIt0iQReW+DieMF4yxbLKDU5ey2QRdDtoAB6 fL9KDhsAw4bpXCsxEXsM84IkQ4wcOItqaACa7txPeKvSxhObdq3u3ibo7wGvdA/BCaL2a869 080UME/15eOkyGKbghoDJzANAmVgTe3RCSMqljVYJ9N2xnG2kB3E7f81hn1vM7PbD8URwoqD oZRdQWvY0hD1TP3KUazZve+Sg7va64sWVlZDz+HVEz2mHycwzUlU28kTNJpxdcVs6qcLmPkh nSevPqM5OUhqjK3JmfvDEvK9AgMBAAGjgdkwgdYwcAYDVR0fBGkwZzBloGOgYYZfaHR0cDov L3BraS50ZWxlc2VjLmRlL2NnaS1iaW4vc2VydmljZS9hZl9Eb3dubG9hZEFSTC5jcmw/LWNy bF9mb3JtYXQ9WF81MDkmLWlzc3Vlcj1EVF9ST09UX0NBXzIwHQYDVR0OBBYEFEm3xs/oPR9/ 6kR7Eyn38QpwPt5kMB8GA1UdIwQYMBaAFDHDeRu69VPXF+CJei0XbAqzK50zMA4GA1UdDwEB /wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgECMA0GCSqGSIb3DQEBBQUAA4IBAQA74Vp3wEgX 3KkY7IGvWonwvSiSpspZGBJw7Cjy565/lizn8l0ZMfYTK3S9vYCyufdnyTmieTvhERHua3iR M347XyYndVNljjNj7s9zw7CSI0khUHUjoR8Y4pSFPT8z6XcgjaK95qGFKUD2P3MyWA0Ja6ba hWzAP7uNZmRWJE6uDT8yNQFb6YyC2XJZT7GGhfF0hVblw/hc843uR7NTBXDn5U2KaYMo4RMJ hp5eyOpYHgwf+aTUWgRo/Sg+iwK2WLX2oSw3VwBnqyNojWOl75lrXP1LVvarQIc01BGSbOyH xQoLBzNytG8MHVQs2FHHzL8w00Ny8TK/jM5JY6gA9/IcMIIFIzCCBAugAwIBAgIECgyxjDAN BgkqhkiG9w0BAQUFADBaMQswCQYDVQQGEwJERTETMBEGA1UEChMKREZOLVZlcmVpbjEQMA4G A1UECxMHREZOLVBLSTEkMCIGA1UEAxMbREZOLVZlcmVpbiBQQ0EgR2xvYmFsIC0gRzAxMB4X DTA3MDMwNjA5MjcyNVoXDTE5MDMwNTAwMDAwMFowgZMxCzAJBgNVBAYTAkRFMSkwJwYDVQQK EyBGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVkYmVyZzEyMDAGA1UEAxMpRmFjaGhvY2hz Y2h1bGUgR2llc3Nlbi1GcmllZGJlcmcgQ0EgLSBHMDIxJTAjBgkqhkiG9w0BCQEWFnBraS1n aWZiQGZoLWdpZXNzZW4uZGUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCygDTi dhueigLG6vjJ69H+k0+5MLR0vOKY+u4AP9e7/peyx+6M42+dB9ghmkbqVHw9G9q89Dd5hpWy wyJ7AAeOSyG4liWgD1jJFeEsIUYC9X/x95hnBlVT+TKJDLjYxlLl1OyMQc/122nG8j1ScjPZ R5e4UkyDaUmFdtr66x3Ak3MEmWqYm7JqjGdl6xYQQzCIe5LWT50eTm1LBJpMjsDYsJ9doZBg bmqAp0UYG9uixWadtKuLBfyCzknitSO0ddD03/MfSunNWLCEL52uaCFobTN8jWJLdEZMN30W jCM9II/Ych2XaI1J/18Nkd+BpZ2yaFivTjICEFosTzdAJNFrAgMBAAGjggG1MIIBsTAPBgNV HRMBAf8EBTADAQH/MAsGA1UdDwQEAwIBBjAdBgNVHQ4EFgQUNNRCwZOju1dsDHfufJUfRkOv MNYwHwYDVR0jBBgwFoAUSbfGz+g9H3/qRHsTKffxCnA+3mQwIQYDVR0RBBowGIEWcGtpLWdp ZmJAZmgtZ2llc3Nlbi5kZTCBiAYDVR0fBIGAMH4wPaA7oDmGN2h0dHA6Ly9jZHAxLnBjYS5k Zm4uZGUvZ2xvYmFsLXJvb3QtY2EvcHViL2NybC9jYWNybC5jcmwwPaA7oDmGN2h0dHA6Ly9j ZHAyLnBjYS5kZm4uZGUvZ2xvYmFsLXJvb3QtY2EvcHViL2NybC9jYWNybC5jcmwwgaIGCCsG AQUFBwEBBIGVMIGSMEcGCCsGAQUFBzAChjtodHRwOi8vY2RwMS5wY2EuZGZuLmRlL2dsb2Jh bC1yb290LWNhL3B1Yi9jYWNlcnQvY2FjZXJ0LmNydDBHBggrBgEFBQcwAoY7aHR0cDovL2Nk cDIucGNhLmRmbi5kZS9nbG9iYWwtcm9vdC1jYS9wdWIvY2FjZXJ0L2NhY2VydC5jcnQwDQYJ KoZIhvcNAQEFBQADggEBABzXcs18pyD/UGNoGaWOxOi6SPJrYY284sQgECHtMhHQRkBAsDdT XwGcL9a+pvNui1l0MXWaoBro7HgPqggxzQqql6H1hjQljBLHG3aU4qiSuFjc8ZOBU9sSC13k ncdqRAKw+bOozj8loRiBHKGh9Oj1KbBlMHWzg01d17WXwAz6j40RWltTvJRHcUo2DW8tGqML yizhH30zKPeemaiT1sBDN06X90VMLQNTmEQ/S/erfqJJaOq31r8w2iQW6IsC0y7kWn5lQAAQ niPDEpmtB8xdo4tOmqUiWlgC1kdTxKnyl7IqrJGjgPBji3L5JZ4ChhEneR6mL8edjrHPjd+X nAUwggVXMIIEP6ADAgECAgQM3KSXMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJERTEp MCcGA1UEChMgRmFjaGhvY2hzY2h1bGUgR2llc3Nlbi1GcmllZGJlcmcxMjAwBgNVBAMTKUZh Y2hob2Noc2NodWxlIEdpZXNzZW4tRnJpZWRiZXJnIENBIC0gRzAyMSUwIwYJKoZIhvcNAQkB FhZwa2ktZ2lmYkBmaC1naWVzc2VuLmRlMB4XDTA4MDkwMjExNDQwN1oXDTExMDkwMjExNDQw N1owZDELMAkGA1UEBhMCREUxKTAnBgNVBAoTIEZhY2hob2Noc2NodWxlIEdpZXNzZW4tRnJp ZWRiZXJnMQ0wCwYDVQQLEwRWRVJXMRswGQYDVQQDExJNaWtoYWlsIExlc2hjaGVua28wggEi MA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDmKCTRqD8jRlMZse7GExFT7JAOh4BfuOS7 Q4U4HHzWUha6qtQ2/RtHz3+dIG1uCIH1/99eRcLr1HiNmvWWuacGURXuIJEGPfJECVcMQOxi nzAhY+6YOSFAyClS9wzoA8BKWwJrjjwSvz5FAL6fmIZs1rr4hY8a93IBj5kIkGQeAyLCGodb 2kAWzPTxmDys5rousHnz8xfZ3kq7BLaJF0y78OlxPuSddeRyalmY8/GyBudwzHojkYPW1erh OCx0dXWu8kjDVdKfvamLDuixnOIKZd4lGs5+iCcJmcsNOVhWc7nHRMbAHB2qe+qrLZb8vyyx InOl3eQIuP9N0obHhpP9AgMBAAGjggHfMIIB2zAJBgNVHRMEAjAAMAsGA1UdDwQEAwIF4DAp BgNVHSUEIjAgBggrBgEFBQcDAgYIKwYBBQUHAwQGCisGAQQBgjcUAgIwHQYDVR0OBBYEFGoX 3ikTS9/UdHapVmwKCgXZFDcJMB8GA1UdIwQYMBaAFDTUQsGTo7tXbAx37nyVH0ZDrzDWMC8G A1UdEQQoMCaBJG1pY2hhZWwubGVzaGNoZW5rb0BpdHMuZmgtZ2llc3Nlbi5kZTCBgwYDVR0f BHwwejA7oDmgN4Y1aHR0cDovL2NkcDEucGNhLmRmbi5kZS9maC1naWZiLWNhL3B1Yi9jcmwv Z19jYWNybC5jcmwwO6A5oDeGNWh0dHA6Ly9jZHAyLnBjYS5kZm4uZGUvZmgtZ2lmYi1jYS9w dWIvY3JsL2dfY2FjcmwuY3JsMIGeBggrBgEFBQcBAQSBkTCBjjBFBggrBgEFBQcwAoY5aHR0 cDovL2NkcDEucGNhLmRmbi5kZS9maC1naWZiLWNhL3B1Yi9jYWNlcnQvZ19jYWNlcnQuY3J0 MEUGCCsGAQUFBzAChjlodHRwOi8vY2RwMi5wY2EuZGZuLmRlL2ZoLWdpZmItY2EvcHViL2Nh Y2VydC9nX2NhY2VydC5jcnQwDQYJKoZIhvcNAQEFBQADggEBAJT4LKgKtwLFf7AiMTX2bHCU Yv0dFndmjpGVRWng9E9//y3ZPZZRF/syfdBqC1ZBYwDTrGSaIVTJyfDlE64iOoQ4hxXzaFKk YvtSUnk606fFUun0NNU+uo7hbxclbYbByp2hWHh/wZFHoltqz403RGydFRgLCNr08LWFwbpu gl+RhvnLa94XsZS7kAZVSJeUlB2UTBE8krThKNORNfi+ZGU3DcFFx9vrw7sT8xDWgisvymhj eDB1N2U5LIoxdCJTO258uUwahBPV0rmiJ5AklzycSyEYroMvWsCBhYV2dy+Qkalbjf+plBOm 4p/u2+Y4iDVA5n270Utrd4ak00zwdyIwggVXMIIEP6ADAgECAgQM3KSXMA0GCSqGSIb3DQEB BQUAMIGTMQswCQYDVQQGEwJERTEpMCcGA1UEChMgRmFjaGhvY2hzY2h1bGUgR2llc3Nlbi1G cmllZGJlcmcxMjAwBgNVBAMTKUZhY2hob2Noc2NodWxlIEdpZXNzZW4tRnJpZWRiZXJnIENB IC0gRzAyMSUwIwYJKoZIhvcNAQkBFhZwa2ktZ2lmYkBmaC1naWVzc2VuLmRlMB4XDTA4MDkw MjExNDQwN1oXDTExMDkwMjExNDQwN1owZDELMAkGA1UEBhMCREUxKTAnBgNVBAoTIEZhY2ho b2Noc2NodWxlIEdpZXNzZW4tRnJpZWRiZXJnMQ0wCwYDVQQLEwRWRVJXMRswGQYDVQQDExJN aWtoYWlsIExlc2hjaGVua28wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDmKCTR qD8jRlMZse7GExFT7JAOh4BfuOS7Q4U4HHzWUha6qtQ2/RtHz3+dIG1uCIH1/99eRcLr1HiN mvWWuacGURXuIJEGPfJECVcMQOxinzAhY+6YOSFAyClS9wzoA8BKWwJrjjwSvz5FAL6fmIZs 1rr4hY8a93IBj5kIkGQeAyLCGodb2kAWzPTxmDys5rousHnz8xfZ3kq7BLaJF0y78OlxPuSd deRyalmY8/GyBudwzHojkYPW1erhOCx0dXWu8kjDVdKfvamLDuixnOIKZd4lGs5+iCcJmcsN OVhWc7nHRMbAHB2qe+qrLZb8vyyxInOl3eQIuP9N0obHhpP9AgMBAAGjggHfMIIB2zAJBgNV HRMEAjAAMAsGA1UdDwQEAwIF4DApBgNVHSUEIjAgBggrBgEFBQcDAgYIKwYBBQUHAwQGCisG AQQBgjcUAgIwHQYDVR0OBBYEFGoX3ikTS9/UdHapVmwKCgXZFDcJMB8GA1UdIwQYMBaAFDTU QsGTo7tXbAx37nyVH0ZDrzDWMC8GA1UdEQQoMCaBJG1pY2hhZWwubGVzaGNoZW5rb0BpdHMu ZmgtZ2llc3Nlbi5kZTCBgwYDVR0fBHwwejA7oDmgN4Y1aHR0cDovL2NkcDEucGNhLmRmbi5k ZS9maC1naWZiLWNhL3B1Yi9jcmwvZ19jYWNybC5jcmwwO6A5oDeGNWh0dHA6Ly9jZHAyLnBj YS5kZm4uZGUvZmgtZ2lmYi1jYS9wdWIvY3JsL2dfY2FjcmwuY3JsMIGeBggrBgEFBQcBAQSB kTCBjjBFBggrBgEFBQcwAoY5aHR0cDovL2NkcDEucGNhLmRmbi5kZS9maC1naWZiLWNhL3B1 Yi9jYWNlcnQvZ19jYWNlcnQuY3J0MEUGCCsGAQUFBzAChjlodHRwOi8vY2RwMi5wY2EuZGZu LmRlL2ZoLWdpZmItY2EvcHViL2NhY2VydC9nX2NhY2VydC5jcnQwDQYJKoZIhvcNAQEFBQAD ggEBAJT4LKgKtwLFf7AiMTX2bHCUYv0dFndmjpGVRWng9E9//y3ZPZZRF/syfdBqC1ZBYwDT rGSaIVTJyfDlE64iOoQ4hxXzaFKkYvtSUnk606fFUun0NNU+uo7hbxclbYbByp2hWHh/wZFH oltqz403RGydFRgLCNr08LWFwbpugl+RhvnLa94XsZS7kAZVSJeUlB2UTBE8krThKNORNfi+ ZGU3DcFFx9vrw7sT8xDWgisvymhjeDB1N2U5LIoxdCJTO258uUwahBPV0rmiJ5AklzycSyEY roMvWsCBhYV2dy+Qkalbjf+plBOm4p/u2+Y4iDVA5n270Utrd4ak00zwdyIxggPbMIID1wIB ATCBnDCBkzELMAkGA1UEBhMCREUxKTAnBgNVBAoTIEZhY2hob2Noc2NodWxlIEdpZXNzZW4t RnJpZWRiZXJnMTIwMAYDVQQDEylGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVkYmVyZyBD QSAtIEcwMjElMCMGCSqGSIb3DQEJARYWcGtpLWdpZmJAZmgtZ2llc3Nlbi5kZQIEDNyklzAJ BgUrDgMCGgUAoIICEzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEP Fw0wODEyMTAwNzI2NTZaMCMGCSqGSIb3DQEJBDEWBBQ3PdzxGia+XdsYnrAMaOs4RCAwjTBS BgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCBrQYJKwYBBAGCNxAEMYGfMIGcMIGTMQsw CQYDVQQGEwJERTEpMCcGA1UEChMgRmFjaGhvY2hzY2h1bGUgR2llc3Nlbi1GcmllZGJlcmcx MjAwBgNVBAMTKUZhY2hob2Noc2NodWxlIEdpZXNzZW4tRnJpZWRiZXJnIENBIC0gRzAyMSUw IwYJKoZIhvcNAQkBFhZwa2ktZ2lmYkBmaC1naWVzc2VuLmRlAgQM3KSXMIGvBgsqhkiG9w0B CRACCzGBn6CBnDCBkzELMAkGA1UEBhMCREUxKTAnBgNVBAoTIEZhY2hob2Noc2NodWxlIEdp ZXNzZW4tRnJpZWRiZXJnMTIwMAYDVQQDEylGYWNoaG9jaHNjaHVsZSBHaWVzc2VuLUZyaWVk YmVyZyBDQSAtIEcwMjElMCMGCSqGSIb3DQEJARYWcGtpLWdpZmJAZmgtZ2llc3Nlbi5kZQIE DNyklzANBgkqhkiG9w0BAQEFAASCAQAM+26tJW3UEtVfThff3c8xEiKH7CC+Ynd0vMCWubYg AcT7/0ylxdnYfq6xOPq4FP3vjU+6dVUSSgdR2JeLxtUgWOtY5X193rdkCKl9aLO3aj9gB/tX hbDMp3jS9WrJ0ZWIg/HI1TH9NEMNXAwWgZmd6vFoN6CSq9Nfejq0EK7OMZjOIO453ool1fLw PJxzWHKVwaC+OzYFV0o5UwBLLifQS+AVq7Ck9C6OSeaW/p6rV8mzMNMFYLPFic4Nai/tsGMR TLwHBHyX3i824nCYe1adEI/CXuYfBSZoGTY5JCLZEGneEUHk4JaxcqU2KXe8p/rPu4NFU/lO wA56spGGVxT+AAAAAAAA --------------ms000104060209070802010201--