psql dump local to remote server: No such file or directory“psql: could not connect to server: No such file...
Phrasing "it says" or "it reads"
Why did moving the mouse cursor cause Windows 95 to run more quickly?
3D nonogram – What's going on?
"Best practices" for formulating MIPs
Why is the saxophone not common in classical repertoire?
Who are the police in Hong Kong?
Are there advantages in writing by hand over typing out a story?
Where is read command?
Isn't "Dave's protocol" good if only the database, and not the code, is leaked?
Is there any connection between "Whispers of the heart" and "The cat returns"?
Is my background sufficient to start Quantum Computing
What verb goes with "coup"?
Puzzling Knight has a Message for all- Especially Newcomers
What instances can be solved today by modern solvers (pure LP)?
When should we use dependency injection (C#)
What is -(-2,3,4)?
Construction of the word подтвержда́ть
What do you call the angle of the direction of an airplane?
Can Monks cast spells?
Did Stalin kill all Soviet officers involved in the Winter War?
What do you call the motor that fuels the movement of a robotic arm?
When do I make my first save against the Web spell?
Is it possible to spoof an IP address to an exact number?
What could a Medieval society do with excess animal blood?
psql dump local to remote server: No such file or directory
“psql: could not connect to server: No such file or directory”CentOS 5: My Postgresql server version is different with my psql client. What should I do?File/directory not being deleted?Psql: Not a directory“psql: could not connect to server: No such file or directory”Postgres Vulnerability through public schema?postgresql doesn't start with LinuxPostgreSQL installation on a Synology DiskStation (DS216j) & pgAdminIIIServer upgrade (yum update) removed psql local installationHow to use archive_command to send archives to remote server (postgres)Using systemd I want my Postgresql ExecStop command to run at shutdown
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
psql -f alldb.sql postgres
output
alldb.sql: No such file or directory
Already tried "psql: could not connect to server: No such file or directory"
and https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-error
No error in /var/log/postgresql/postgresql-9.5-main.log
2019-07-01 22:00:53 IST [2514-1] LOG: autovacuum launcher started
2019-07-01 22:00:53 IST [2509-1] LOG: database system is ready to accept >connections
2019-07-01 22:00:53 IST [2517-1] [unknown]@[unknown] LOG: incomplete >startup packet
2019-07-01 22:01:20 IST [2892-1] iitians@postgres FATAL: role "iitians" >does not exist
2019-07-01 22:03:31 IST [2924-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 22:03:48 IST [2933-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 23:22:40 IST [4052-1] root@postgres FATAL: role "root" does not >exist
2019-07-01 23:35:08 IST [2509-2] LOG: received fast shutdown request
2019-07-01 23:35:08 IST [2509-3] LOG: aborting any active transactions
2019-07-01 23:35:08 IST [2514-2] LOG: autovacuum launcher shutting down
2019-07-01 23:35:08 IST [2511-1] LOG: shutting down
2019-07-01 23:35:08 IST [2511-2] LOG: database system is shut down
2019-07-01 23:35:09 IST [4176-1] LOG: database system was shut down at >2019-07-01 23:35:08 IST
2019-07-01 23:35:09 IST [4176-2] LOG: MultiXact member wraparound >protections are now enabled
2019-07-01 23:35:09 IST [4180-1] LOG: autovacuum launcher started
2019-07-01 23:35:09 IST [4175-1] LOG: database system is ready to accept >connections
2019-07-01 23:35:09 IST [4182-1] [unknown]@[unknown] LOG: incomplete >startup packet
postgresql
asked 9 hours ago
jagtarjagtar
11 bronze badge
New contributor
jagtar 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 |
psql -f alldb.sql postgres
output
alldb.sql: No such file or directory
Already tried "psql: could not connect to server: No such file or directory"
and https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-error
No error in /var/log/postgresql/postgresql-9.5-main.log
2019-07-01 22:00:53 IST [2514-1] LOG: autovacuum launcher started
2019-07-01 22:00:53 IST [2509-1] LOG: database system is ready to accept >connections
2019-07-01 22:00:53 IST [2517-1] [unknown]@[unknown] LOG: incomplete >startup packet
2019-07-01 22:01:20 IST [2892-1] iitians@postgres FATAL: role "iitians" >does not exist
2019-07-01 22:03:31 IST [2924-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 22:03:48 IST [2933-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 23:22:40 IST [4052-1] root@postgres FATAL: role "root" does not >exist
2019-07-01 23:35:08 IST [2509-2] LOG: received fast shutdown request
2019-07-01 23:35:08 IST [2509-3] LOG: aborting any active transactions
2019-07-01 23:35:08 IST [2514-2] LOG: autovacuum launcher shutting down
2019-07-01 23:35:08 IST [2511-1] LOG: shutting down
2019-07-01 23:35:08 IST [2511-2] LOG: database system is shut down
2019-07-01 23:35:09 IST [4176-1] LOG: database system was shut down at >2019-07-01 23:35:08 IST
2019-07-01 23:35:09 IST [4176-2] LOG: MultiXact member wraparound >protections are now enabled
2019-07-01 23:35:09 IST [4180-1] LOG: autovacuum launcher started
2019-07-01 23:35:09 IST [4175-1] LOG: database system is ready to accept >connections
2019-07-01 23:35:09 IST [4182-1] [unknown]@[unknown] LOG: incomplete >startup packet
postgresql
asked 9 hours ago
jagtarjagtar
11 bronze badge
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Don't you think you should ask a proper question instead of only dumping some unformatted logs here?
– RalfFriedl
9 hours ago
U mean to say this was proper unix.stackexchange.com/questions/285080/… but i tried all it didnt solved. If u want u can block the account
– jagtar
9 hours ago
Your error isalldb.sql: No such file or directory, which indicates that thepsqlcommand you ran could not find the filealldb.sqlwhich you indicated with the-fflag. Is there a filealldb.sqlin the directory you are running thepsqlcommand? Where is this file?
– GracefulRestart
7 hours ago
alldb.sql is in my local machine under /users/jagtarsingh/ which i want to dump to remote server i have logged in as superuser postgres
– jagtar
7 hours ago
add a comment |
psql -f alldb.sql postgres
output
alldb.sql: No such file or directory
Already tried "psql: could not connect to server: No such file or directory"
and https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-error
No error in /var/log/postgresql/postgresql-9.5-main.log
2019-07-01 22:00:53 IST [2514-1] LOG: autovacuum launcher started
2019-07-01 22:00:53 IST [2509-1] LOG: database system is ready to accept >connections
2019-07-01 22:00:53 IST [2517-1] [unknown]@[unknown] LOG: incomplete >startup packet
2019-07-01 22:01:20 IST [2892-1] iitians@postgres FATAL: role "iitians" >does not exist
2019-07-01 22:03:31 IST [2924-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 22:03:48 IST [2933-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 23:22:40 IST [4052-1] root@postgres FATAL: role "root" does not >exist
2019-07-01 23:35:08 IST [2509-2] LOG: received fast shutdown request
2019-07-01 23:35:08 IST [2509-3] LOG: aborting any active transactions
2019-07-01 23:35:08 IST [2514-2] LOG: autovacuum launcher shutting down
2019-07-01 23:35:08 IST [2511-1] LOG: shutting down
2019-07-01 23:35:08 IST [2511-2] LOG: database system is shut down
2019-07-01 23:35:09 IST [4176-1] LOG: database system was shut down at >2019-07-01 23:35:08 IST
2019-07-01 23:35:09 IST [4176-2] LOG: MultiXact member wraparound >protections are now enabled
2019-07-01 23:35:09 IST [4180-1] LOG: autovacuum launcher started
2019-07-01 23:35:09 IST [4175-1] LOG: database system is ready to accept >connections
2019-07-01 23:35:09 IST [4182-1] [unknown]@[unknown] LOG: incomplete >startup packet
postgresql
asked 9 hours ago
jagtarjagtar
11 bronze badge
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
psql -f alldb.sql postgres
output
alldb.sql: No such file or directory
Already tried "psql: could not connect to server: No such file or directory"
and https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-error
No error in /var/log/postgresql/postgresql-9.5-main.log
2019-07-01 22:00:53 IST [2514-1] LOG: autovacuum launcher started
2019-07-01 22:00:53 IST [2509-1] LOG: database system is ready to accept >connections
2019-07-01 22:00:53 IST [2517-1] [unknown]@[unknown] LOG: incomplete >startup packet
2019-07-01 22:01:20 IST [2892-1] iitians@postgres FATAL: role "iitians" >does not exist
2019-07-01 22:03:31 IST [2924-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 22:03:48 IST [2933-1] root@postgres FATAL: role "root" does >not exist
2019-07-01 23:22:40 IST [4052-1] root@postgres FATAL: role "root" does not >exist
2019-07-01 23:35:08 IST [2509-2] LOG: received fast shutdown request
2019-07-01 23:35:08 IST [2509-3] LOG: aborting any active transactions
2019-07-01 23:35:08 IST [2514-2] LOG: autovacuum launcher shutting down
2019-07-01 23:35:08 IST [2511-1] LOG: shutting down
2019-07-01 23:35:08 IST [2511-2] LOG: database system is shut down
2019-07-01 23:35:09 IST [4176-1] LOG: database system was shut down at >2019-07-01 23:35:08 IST
2019-07-01 23:35:09 IST [4176-2] LOG: MultiXact member wraparound >protections are now enabled
2019-07-01 23:35:09 IST [4180-1] LOG: autovacuum launcher started
2019-07-01 23:35:09 IST [4175-1] LOG: database system is ready to accept >connections
2019-07-01 23:35:09 IST [4182-1] [unknown]@[unknown] LOG: incomplete >startup packet
postgresql
postgresql
asked 9 hours ago
jagtarjagtar
11 bronze badge
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 9 hours ago
jagtarjagtar
11 bronze badge
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 28 mins ago
jagtar
asked 9 hours ago
jagtarjagtar
11 bronze badge
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 9 hours ago
jagtarjagtar
11 bronze badge
asked 9 hours ago
jagtarjagtar
11 bronze badge
11 bronze badge
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
jagtar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Don't you think you should ask a proper question instead of only dumping some unformatted logs here?
– RalfFriedl
9 hours ago
U mean to say this was proper unix.stackexchange.com/questions/285080/… but i tried all it didnt solved. If u want u can block the account
– jagtar
9 hours ago
Your error isalldb.sql: No such file or directory, which indicates that thepsqlcommand you ran could not find the filealldb.sqlwhich you indicated with the-fflag. Is there a filealldb.sqlin the directory you are running thepsqlcommand? Where is this file?
– GracefulRestart
7 hours ago
alldb.sql is in my local machine under /users/jagtarsingh/ which i want to dump to remote server i have logged in as superuser postgres
– jagtar
7 hours ago
add a comment |
Don't you think you should ask a proper question instead of only dumping some unformatted logs here?
– RalfFriedl
9 hours ago
U mean to say this was proper unix.stackexchange.com/questions/285080/… but i tried all it didnt solved. If u want u can block the account
– jagtar
9 hours ago
Your error isalldb.sql: No such file or directory, which indicates that thepsqlcommand you ran could not find the filealldb.sqlwhich you indicated with the-fflag. Is there a filealldb.sqlin the directory you are running thepsqlcommand? Where is this file?
– GracefulRestart
7 hours ago
alldb.sql is in my local machine under /users/jagtarsingh/ which i want to dump to remote server i have logged in as superuser postgres
– jagtar
7 hours ago
Don't you think you should ask a proper question instead of only dumping some unformatted logs here?
– RalfFriedl
9 hours ago
Don't you think you should ask a proper question instead of only dumping some unformatted logs here?
– RalfFriedl
9 hours ago
U mean to say this was proper unix.stackexchange.com/questions/285080/… but i tried all it didnt solved. If u want u can block the account
– jagtar
9 hours ago
U mean to say this was proper unix.stackexchange.com/questions/285080/… but i tried all it didnt solved. If u want u can block the account
– jagtar
9 hours ago
Your error is
alldb.sql: No such file or directory, which indicates that the psql command you ran could not find the file alldb.sql which you indicated with the -f flag. Is there a file alldb.sql in the directory you are running the psql command? Where is this file?– GracefulRestart
7 hours ago
Your error is
alldb.sql: No such file or directory, which indicates that the psql command you ran could not find the file alldb.sql which you indicated with the -f flag. Is there a file alldb.sql in the directory you are running the psql command? Where is this file?– GracefulRestart
7 hours ago
alldb.sql is in my local machine under /users/jagtarsingh/ which i want to dump to remote server i have logged in as superuser postgres
– jagtar
7 hours ago
alldb.sql is in my local machine under /users/jagtarsingh/ which i want to dump to remote server i have logged in as superuser postgres
– jagtar
7 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
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
});
}
});
jagtar is a new contributor. Be nice, and check out our Code of Conduct.
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%2funix.stackexchange.com%2fquestions%2f527908%2fpsql-dump-local-to-remote-server-no-such-file-or-directory%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
jagtar is a new contributor. Be nice, and check out our Code of Conduct.
jagtar is a new contributor. Be nice, and check out our Code of Conduct.
jagtar is a new contributor. Be nice, and check out our Code of Conduct.
jagtar is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- 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.
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%2funix.stackexchange.com%2fquestions%2f527908%2fpsql-dump-local-to-remote-server-no-such-file-or-directory%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
Don't you think you should ask a proper question instead of only dumping some unformatted logs here?
– RalfFriedl
9 hours ago
U mean to say this was proper unix.stackexchange.com/questions/285080/… but i tried all it didnt solved. If u want u can block the account
– jagtar
9 hours ago
Your error is
alldb.sql: No such file or directory, which indicates that thepsqlcommand you ran could not find the filealldb.sqlwhich you indicated with the-fflag. Is there a filealldb.sqlin the directory you are running thepsqlcommand? Where is this file?– GracefulRestart
7 hours ago
alldb.sql is in my local machine under /users/jagtarsingh/ which i want to dump to remote server i have logged in as superuser postgres
– jagtar
7 hours ago