How to check PostgreSQL database integrity? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30UTC (7:30pm US/Eastern) Come Celebrate our 10 Year Anniversary!Postgres: How can I see all SQL statements being executed by the database server?How to verify integrity of a remote file transferHow to see active connections and “current activity” in PostgreSQL 8.4Merging Postgresql dump with production databaseSQL: Find Last Integrity Check DateExport and import a PostgreSQL database with a different name?100 terabytes database on PostgreSQL without shardingTransferring PostgreSQL Database Between ServersDB2 Integrity Checks and Exception Tablespostgresql log queries single database
Does the Mueller report show a conspiracy between Russia and the Trump Campaign?
What does this say in Elvish?
Is CEO the "profession" with the most psychopaths?
1-probability to calculate two events in a row
If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?
Is there public access to the Meteor Crater in Arizona?
Why are my pictures showing a dark band on one edge?
How to pronounce 伝統色
Most bit efficient text communication method?
How would a mousetrap for use in space work?
Semigroups with no morphisms between them
How does the math work when buying airline miles?
What does Turing mean by this statement?
What is an "asse" in Elizabethan English?
One-one communication
What are the discoveries that have been possible with the rejection of positivism?
What would you call this weird metallic apparatus that allows you to lift people?
What does it mean that physics no longer uses mechanical models to describe phenomena?
Is it fair for a professor to grade us on the possession of past papers?
AppleTVs create a chatty alternate WiFi network
How can I set the aperture on my DSLR when it's attached to a telescope instead of a lens?
Flash light on something
What is the difference between a "ranged attack" and a "ranged weapon attack"?
Would it be easier to apply for a UK visa if there is a host family to sponsor for you in going there?
How to check PostgreSQL database integrity?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30UTC (7:30pm US/Eastern)
Come Celebrate our 10 Year Anniversary!Postgres: How can I see all SQL statements being executed by the database server?How to verify integrity of a remote file transferHow to see active connections and “current activity” in PostgreSQL 8.4Merging Postgresql dump with production databaseSQL: Find Last Integrity Check DateExport and import a PostgreSQL database with a different name?100 terabytes database on PostgreSQL without shardingTransferring PostgreSQL Database Between ServersDB2 Integrity Checks and Exception Tablespostgresql log queries single database
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
7
Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.
database postgresql data-integrity
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
add a comment |
7
Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.
database postgresql data-integrity
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
1
pgcheck.projects.postgresql.org
– Prix
Aug 29 '10 at 15:54
@Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever.
– winwaed
Feb 2 '11 at 16:41
add a comment |
7
7
7
1
Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.
database postgresql data-integrity
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.
database postgresql data-integrity
database postgresql data-integrity
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
asked Aug 29 '10 at 15:46
FooBarFooBar
183237
183237
1
pgcheck.projects.postgresql.org
– Prix
Aug 29 '10 at 15:54
@Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever.
– winwaed
Feb 2 '11 at 16:41
add a comment |
1
pgcheck.projects.postgresql.org
– Prix
Aug 29 '10 at 15:54
@Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever.
– winwaed
Feb 2 '11 at 16:41
1
1
pgcheck.projects.postgresql.org
– Prix
Aug 29 '10 at 15:54
pgcheck.projects.postgresql.org
– Prix
Aug 29 '10 at 15:54
@Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever.
– winwaed
Feb 2 '11 at 16:41
@Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever.
– winwaed
Feb 2 '11 at 16:41
add a comment |
2 Answers
2
active
oldest
votes
1
There exists a tool named pgcheck that checks the integrity of data files:
- http://pgfoundry.org/projects/pgcheck/
- http://pgcheck.projects.postgresql.org/
edited Apr 14 at 3:17
meshy
1054
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
add a comment |
0
What do you really want to achieve?
The database itself guarantees its integrity. You do not need tools to fiddle with.
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
1
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f175865%2fhow-to-check-postgresql-database-integrity%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
There exists a tool named pgcheck that checks the integrity of data files:
- http://pgfoundry.org/projects/pgcheck/
- http://pgcheck.projects.postgresql.org/
edited Apr 14 at 3:17
meshy
1054
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
add a comment |
1
There exists a tool named pgcheck that checks the integrity of data files:
- http://pgfoundry.org/projects/pgcheck/
- http://pgcheck.projects.postgresql.org/
edited Apr 14 at 3:17
meshy
1054
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
add a comment |
1
1
1
There exists a tool named pgcheck that checks the integrity of data files:
- http://pgfoundry.org/projects/pgcheck/
- http://pgcheck.projects.postgresql.org/
edited Apr 14 at 3:17
meshy
1054
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
There exists a tool named pgcheck that checks the integrity of data files:
- http://pgfoundry.org/projects/pgcheck/
- http://pgcheck.projects.postgresql.org/
edited Apr 14 at 3:17
meshy
1054
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
edited Apr 14 at 3:17
meshy
1054
edited Apr 14 at 3:17
meshy
1054
edited Apr 14 at 3:17
meshy
1054
1054
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
answered Aug 29 '10 at 20:26
alerootaleroot
2,76152436
2,76152436
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
add a comment |
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
pgcheck seems to have not released any files.
– Arthur Ulfeldt
Jan 13 '11 at 22:33
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
And last pgCheck activity is in 2007. Doesn't look very active.
– winwaed
Feb 2 '11 at 16:39
add a comment |
0
What do you really want to achieve?
The database itself guarantees its integrity. You do not need tools to fiddle with.
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
1
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
add a comment |
0
What do you really want to achieve?
The database itself guarantees its integrity. You do not need tools to fiddle with.
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
1
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
add a comment |
0
0
0
What do you really want to achieve?
The database itself guarantees its integrity. You do not need tools to fiddle with.
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
What do you really want to achieve?
The database itself guarantees its integrity. You do not need tools to fiddle with.
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
answered Aug 29 '10 at 18:08
cstamascstamas
5,8971739
5,8971739
1
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
add a comment |
1
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
1
1
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
Does the database itself guarantees its integrity when, for example, the server has a bad RAM that crunches bits?
– FooBar
Aug 29 '10 at 23:43
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
@FooBar: no I think it does not (it can be that some detection mechanism exists). If you have bad RAM the whole operating system will crash sooner or later. This problem should/could be avoided with ECC memory. If you have bad memory you are pretty much out of luck anyways (IMHO).
– cstamas
Sep 1 '10 at 22:52
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
The question of database integrity is a question I have at the moment. It would explain some problems and it would be nice to be able to cross it off the list of potential causes. It seems that bad memory or disk could lead to db inconsistencies.
– winwaed
Feb 2 '11 at 16:40
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f175865%2fhow-to-check-postgresql-database-integrity%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
pgcheck.projects.postgresql.org
– Prix
Aug 29 '10 at 15:54
@Prix, pgCheck has not seen any activity in three years. It doesn't seem like a very good solution. And Arthur ulfeldt (see below) reports no files released ever.
– winwaed
Feb 2 '11 at 16:41