Thread: How to run query by command prompt in Postgres

How to run query by command prompt in Postgres

From
"Kapil Kr. Khandelwal"
Date:
Dear Team

I want to a favour from your side. I want to know, how to run sql query by
command prompt in postgres sql.

I ma waiting for your positive response.


Thanks & Regards

Kapil Kr. Khandelwal
M: 09694179109
CodeScape Consultants, Jaipur

Re: How to run query by command prompt in Postgres

From
Christopher Browne
Date:
On Wed, Jun 27, 2012 at 7:15 AM, Kapil Kr. Khandelwal <kapilk@cscape.in> wrote:
> I want to a favour from your side. I want to know, how to run sql query by
> command prompt in postgres sql.

This doesn't sound like a bug, and this mailing list is intended to
capture bugs discovered in Postgres.

Perhaps you should avail yourself of the documentation.  The following
links seem as though they may be relevant:

http://www.postgresql.org/docs/9.1/static/tutorial-accessdb.html
http://www.postgresql.org/docs/9.1/static/app-psql.html
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"

Re: How to run query by command prompt in Postgres

From
Craig Ringer
Date:
On 06/27/2012 07:15 PM, Kapil Kr. Khandelwal wrote:
> Dear Team
>
> I want to a favour from your side. I want to know, how to run sql
> query by command prompt in postgres sql.

psql

http://www.postgresql.org/docs/9.1/static/app-psql.html

--
Craig Ringer

Re: How to run query by command prompt in Postgres

From
"Kapil Kr. Khandelwal"
Date:
Dear Sir


Thanks for your response. My problem has solved.

Thanks & Regards

Kapil Kr. Khandelwal
M: 09694179109
CodeScape Consultants, Jaipur



On Wed, Jun 27, 2012 at 8:30 PM, Christopher Browne <cbbrowne@gmail.com>wrote:

> On Wed, Jun 27, 2012 at 7:15 AM, Kapil Kr. Khandelwal <kapilk@cscape.in>
> wrote:
> > I want to a favour from your side. I want to know, how to run sql query
> by
> > command prompt in postgres sql.
>
> This doesn't sound like a bug, and this mailing list is intended to
> capture bugs discovered in Postgres.
>
> Perhaps you should avail yourself of the documentation.  The following
> links seem as though they may be relevant:
>
> http://www.postgresql.org/docs/9.1/static/tutorial-accessdb.html
> http://www.postgresql.org/docs/9.1/static/app-psql.html
> --
> When confronted by a difficult problem, solve it by reducing it to the
> question, "How would the Lone Ranger handle this?"
>

Re: How to run query by command prompt in Postgres

From
"Kapil Kr. Khandelwal"
Date:
Dear Team


When I restarted the postgres9.0 service by windows then getting following
error message. Plz help me.

*Error Message(Error 1053) :  The service did not respond start or control
requested  in timely fashion. *
*
*
Please suggest me. Thanks in advance.




Thanks & Regards

Kapil Kr. Khandelwal
M: 09694179109
CodeScape Consultants, Jaipur



On Wed, Jun 27, 2012 at 4:45 PM, Kapil Kr. Khandelwal <kapilk@cscape.in>wrote:

> Dear Team
>
> I want to a favour from your side. I want to know, how to run sql query by
> command prompt in postgres sql.
>
> I ma waiting for your positive response.
>
>
> Thanks & Regards
>
> Kapil Kr. Khandelwal
> M: 09694179109
> CodeScape Consultants, Jaipur
>
>

Re: How to run query by command prompt in Postgres

From
Daniel Farina
Date:
On Jun 28, 2012 7:44 AM, "Kapil Kr. Khandelwal" <kapilk@cscape.in> wrote:
>
> Dear Team
>
>
> When I restarted the postgres9.0 service by windows then getting
following error message. Plz help me.
>
> Error Message(Error 1053) :  The service did not respond start or control
requested  in timely fashion.
>
> Please suggest me. Thanks in advance

Please post general requests for help in pgsql-general or pgsql-novice. If
the cause of this problem is obscure and looks like a bug, then it would be
appropriate to post it here.

This list is for tracking clear and precise defects in Postgres. Please do
not discuss other things here.

Re: How to run query by command prompt in Postgres

From
"Kapil Kr. Khandelwal"
Date:
Dear Team

I want to a favour from your side. I want to implement clustering in
postgres on windows server.  Please provide the list of steps. I want the
 answers of followings doubts.

1. How to write archive command
2. How to log shipping from primary to stand by server
3. how to restore database at stand by server from archived files

I am waiting for your positive response. Thanks in advance.


Regards
Kapil Kr. Khandelwal
CodeScape Consultant Pvt Ltd
+91 969 417 9109
+91 141 400 2993
www.codescape.in

 *Think before printing. Turn off Systems before leaving. Conserve Energy,
Save our Environment.*




On Wed, Jun 27, 2012 at 9:10 PM, Kapil Kr. Khandelwal <kapilk@cscape.in>wrote:

> Dear Sir
>
>
> Thanks for your response. My problem has solved.
>
> Thanks & Regards
>
> Kapil Kr. Khandelwal
> M: 09694179109
> CodeScape Consultants, Jaipur
>
>
>
> On Wed, Jun 27, 2012 at 8:30 PM, Christopher Browne <cbbrowne@gmail.com>wrote:
>
>> On Wed, Jun 27, 2012 at 7:15 AM, Kapil Kr. Khandelwal <kapilk@cscape.in>
>> wrote:
>> > I want to a favour from your side. I want to know, how to run sql query
>> by
>> > command prompt in postgres sql.
>>
>> This doesn't sound like a bug, and this mailing list is intended to
>> capture bugs discovered in Postgres.
>>
>> Perhaps you should avail yourself of the documentation.  The following
>> links seem as though they may be relevant:
>>
>> http://www.postgresql.org/docs/9.1/static/tutorial-accessdb.html
>> http://www.postgresql.org/docs/9.1/static/app-psql.html
>> --
>> When confronted by a difficult problem, solve it by reducing it to the
>> question, "How would the Lone Ranger handle this?"
>>
>
>

Re: How to run query by command prompt in Postgres

From
Christopher Browne
Date:
On Wed, Mar 20, 2013 at 8:22 AM, Kapil Kr. Khandelwal <kapilk@cscape.in> wrote:
> Dear Team
>
> I want to a favour from your side. I want to implement clustering in
> postgres on windows server.  Please provide the list of steps. I want the
> answers of followings doubts.
>
> 1. How to write archive command
> 2. How to log shipping from primary to stand by server
> 3. how to restore database at stand by server from archived files
>
> I am waiting for your positive response. Thanks in advance.

Again, these do not sound like they are bugs in PostgreSQL that
should be reported here.

They could indicate bugs in the documentation if the documentation was
specifically deficient, but it is not evident that you have reviewed the
documentation, as I would expect different "doubts."

I don't know what version of PostgreSQL you are using; if you were
running 9.2, then the following might be relevant documentation:
  <http://www.postgresql.org/docs/9.2/static/continuous-archiving.html>

That seems to describe the things you seem to be asking about.
If it is, then you should avail yourself of the documentation.

It is decidedly not a bug in PostgreSQL for you to fail to read the
documentation, and you should not report such things on this
mailing list.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"