Sfrgttk

Finding a basis of an infinite dimensional vector space with a given vector

Does the race of half-elves on Khorvaire in Eberron have its own name?

How to play song that contains one guitar when we have two guitarists (or more)?

Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?

How to write a character overlapping another character

The totem pole can be grouped into

Uncountable set with a non-discrete metric

Is there a technology capable of disabling the whole of Earth's satellitle network?

How to make clear what a part-humanoid character looks like when they're quite common in their world?

Workplace intimidation due to child's chronic health condition

find command cannot find my files which do exist

Does a code with length 6, size 32 and distance 2 exist?

Have any astronauts or cosmonauts died in space?

Why is autolanding ILS a thing, but not autotakeoffing ITS?

Why is it a problem for Freddie if the guys from Munich did what he wanted?

Are there any rules or guidelines about the order of saving throws?

Suggestions on how to improve logo

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Headless horseman claims new head

Is layered encryption more secure than long passwords?

How to draw these kind of adjacent ovals with arrows in latex?

Why don't hotels offer (at least) 1 kitchen bookable by any guest?

How bad is a Computer Science course that doesn't teach Design Patterns?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

pg_resetxlog command not found

Why is postgresql still consuming space on my other drive?which postgres do i have installed? what directory needs to be in my path to run initdb?Moving postgresql data directoryPostgreSQL not running on Macunable to run postgres with pg_ctlpostgresql.conf file found in both /usr/share/postgresql and /etc/postgresql/errors install and start postgresql-9.5“Main” folder is not found at “/var/lib/postgresql/9.3/”pg_upgrade doesn't find config filepostgresql service job does nothing

0

I can't find pg_resetxlog under /usr/bin.

postgres (PostgreSQL) 10.7 (Ubuntu 10.7-1.pgdg16.04+1)

cd /usr/bin

postgres@node-1:/usr/bin$ ./pg_resetxlog

-su: ./pg_resetxlog: No such file or directory

postgresql postgresql-10

share|improve this question

edited 2 days ago

Colin 't Hart

6,53682533

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

add a comment | 

0

I can't find pg_resetxlog under /usr/bin.

postgres (PostgreSQL) 10.7 (Ubuntu 10.7-1.pgdg16.04+1)

cd /usr/bin

postgres@node-1:/usr/bin$ ./pg_resetxlog

-su: ./pg_resetxlog: No such file or directory

postgresql postgresql-10

share|improve this question

edited 2 days ago

Colin 't Hart

6,53682533

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

add a comment | 

I can't find pg_resetxlog under /usr/bin.

postgres (PostgreSQL) 10.7 (Ubuntu 10.7-1.pgdg16.04+1)

cd /usr/bin

postgres@node-1:/usr/bin$ ./pg_resetxlog

-su: ./pg_resetxlog: No such file or directory

postgresql postgresql-10

share|improve this question

edited 2 days ago

Colin 't Hart

6,53682533

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

cd /usr/bin

postgres@node-1:/usr/bin$ ./pg_resetxlog

-su: ./pg_resetxlog: No such file or directory

share|improve this question

edited 2 days ago

Colin 't Hart

6,53682533

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

share|improve this question

edited 2 days ago

Colin 't Hart

6,53682533

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

edited 2 days ago

Colin 't Hart

6,53682533

edited 2 days ago

Colin 't Hart

6,53682533

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

asked Feb 17 at 2:27

CJ ChangCJ Chang

12

2 Answers
2

active

oldest

votes

2

That's because from version 10 it has been renamed to pg_resetwal. And the binary is located in /usr/lib/postgresql/<version>/bin.

The pg_xlog directory was renamed to pg_wal in version 10 and several functions, tools and options as well, to reflect that change. See Postgres 10 release notes:

• 
  

  Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier)

  
  
  

  Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.

  
  


• 
  

  Rename SQL functions, tools, and options that reference xlog to wal (Robert Haas)

  
  
  

  For example, pg_switch_xlog() becomes pg_switch_wal(), pg_receivexlog becomes pg_receivewal, and --xlogdir becomes --waldir. This is for consistency with the change of the pg_xlog directory name; in general, the xlog terminology is no longer used in any user-facing places.

  
  

share|improve this answer

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not there. postgres@node-1:/usr/lib/postgresql/10/bin$ ls clusterdb dropdb oid2name pgbench pg_dump pg_receivewal pg_restore pg_test_fsync pg_waldump psql repmgrd createdb dropuser pg_archivecleanup pg_controldata pg_dumpall pg_recvlogical pg_rewind pg_test_timing postgres reindexdb vacuumdb createuser initdb pg_basebackup pg_ctl pg_isready pg_resetwal pg_standby pg_upgrade postmaster repmgr vacuumlo
  
  – CJ Chang
  18 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I see pg_resetwal right there.
  
  – Colin 't Hart
  18 hours ago
  

  
  
  
  

add a comment | 

0

It is in /usr/lib/postgresql/version.number/bin

share|improve this answer

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1

New contributor

Sergey Papyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229961%2fpg-resetxlog-command-not-found%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

2

That's because from version 10 it has been renamed to pg_resetwal. And the binary is located in /usr/lib/postgresql/<version>/bin.

The pg_xlog directory was renamed to pg_wal in version 10 and several functions, tools and options as well, to reflect that change. See Postgres 10 release notes:

• 
  

  Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier)

  
  
  

  Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.

  
  


• 
  

  Rename SQL functions, tools, and options that reference xlog to wal (Robert Haas)

  
  
  

  For example, pg_switch_xlog() becomes pg_switch_wal(), pg_receivexlog becomes pg_receivewal, and --xlogdir becomes --waldir. This is for consistency with the change of the pg_xlog directory name; in general, the xlog terminology is no longer used in any user-facing places.

  
  

share|improve this answer

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not there. postgres@node-1:/usr/lib/postgresql/10/bin$ ls clusterdb dropdb oid2name pgbench pg_dump pg_receivewal pg_restore pg_test_fsync pg_waldump psql repmgrd createdb dropuser pg_archivecleanup pg_controldata pg_dumpall pg_recvlogical pg_rewind pg_test_timing postgres reindexdb vacuumdb createuser initdb pg_basebackup pg_ctl pg_isready pg_resetwal pg_standby pg_upgrade postmaster repmgr vacuumlo
  
  – CJ Chang
  18 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I see pg_resetwal right there.
  
  – Colin 't Hart
  18 hours ago
  

  
  
  
  

add a comment | 

2

That's because from version 10 it has been renamed to pg_resetwal. And the binary is located in /usr/lib/postgresql/<version>/bin.

The pg_xlog directory was renamed to pg_wal in version 10 and several functions, tools and options as well, to reflect that change. See Postgres 10 release notes:

• 
  

  Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier)

  
  
  

  Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.

  
  


• 
  

  Rename SQL functions, tools, and options that reference xlog to wal (Robert Haas)

  
  
  

  For example, pg_switch_xlog() becomes pg_switch_wal(), pg_receivexlog becomes pg_receivewal, and --xlogdir becomes --waldir. This is for consistency with the change of the pg_xlog directory name; in general, the xlog terminology is no longer used in any user-facing places.

  
  

share|improve this answer

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not there. postgres@node-1:/usr/lib/postgresql/10/bin$ ls clusterdb dropdb oid2name pgbench pg_dump pg_receivewal pg_restore pg_test_fsync pg_waldump psql repmgrd createdb dropuser pg_archivecleanup pg_controldata pg_dumpall pg_recvlogical pg_rewind pg_test_timing postgres reindexdb vacuumdb createuser initdb pg_basebackup pg_ctl pg_isready pg_resetwal pg_standby pg_upgrade postmaster repmgr vacuumlo
  
  – CJ Chang
  18 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I see pg_resetwal right there.
  
  – Colin 't Hart
  18 hours ago
  

  
  
  
  

add a comment | 

That's because from version 10 it has been renamed to pg_resetwal. And the binary is located in /usr/lib/postgresql/<version>/bin.

The pg_xlog directory was renamed to pg_wal in version 10 and several functions, tools and options as well, to reflect that change. See Postgres 10 release notes:

• 
  

  Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier)

  
  
  

  Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.

  
  


• 
  

  Rename SQL functions, tools, and options that reference xlog to wal (Robert Haas)

  
  
  

  For example, pg_switch_xlog() becomes pg_switch_wal(), pg_receivexlog becomes pg_receivewal, and --xlogdir becomes --waldir. This is for consistency with the change of the pg_xlog directory name; in general, the xlog terminology is no longer used in any user-facing places.

  
  

share|improve this answer

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

share|improve this answer

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

edited 7 mins ago

ypercubeᵀᴹ

76.6k11132214

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

answered 2 days ago

Colin 't HartColin 't Hart

6,53682533

0

It is in /usr/lib/postgresql/version.number/bin

share|improve this answer

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1

New contributor

Sergey Papyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

It is in /usr/lib/postgresql/version.number/bin

share|improve this answer

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1

New contributor

Sergey Papyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

It is in /usr/lib/postgresql/version.number/bin

share|improve this answer

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1

New contributor

Sergey Papyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this answer

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1

New contributor

Sergey Papyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1

New contributor

Sergey Papyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered Feb 17 at 4:05

Sergey PapyanSergey Papyan

1