* Hagen Finley:
> Yes but I couldn't input your second line - the ('ä,ß,ö') was not
> possible via the psql client - just got beeped when I tried to type or
> paste those characters.
If you start "cat" instead of "psql", can you enter those characters?
What about "python" or the shell itself? Wha
2012/1/3 roberto sanchez muñoz
> i tried but still had the same error and i dont know how to see the logs
> $ cd /usr/local/Cellar/postgresql/9.1.2/bin/
> $ ./pg_ctl -D /usr/local/var/postgres stop -mi
> waiting for server to shut
> down
i tried but still had the same error and i dont know how to see the logs
$ cd /usr/local/Cellar/postgresql/9.1.2/bin/
$ ./pg_ctl -D /usr/local/var/postgres stop -mi
waiting for server to shut
down... failed
pg_ctl: server does not shut do
On 01/02/12 10:10 PM, roberto sanchez muñoz wrote:
i tried but still had the same error and i dont know how to see the logs
/usr/local/var/postgres/server.log is probably your log, as thats what
your PS output shows was the -r argument...its that or its in
/usr/local/var/postgres/pg_log/
Am 02.01.2012 20:13, schrieb Hagen Finley:
> I am using psql (8.2.15) and I would like to input German characters
> (e.g. ä,ß,ö) into char fields I have in a database
I see that you are using Outlook which leads me to assume you are
running Windows as host for your transaction. Therefor you might
On 01/02/12 6:21 PM, Hagen Finley wrote:
Yes but I couldn't input your second line - the ('ä,ß,ö') was not possible via
the psql client - just got beeped when I tried to type or paste those
characters.
the problem is, MS Windows and only MS Windows uses UTF16 instead of the
UTF8 that the en
Simon Windsor wrote:
[pg_largeobject keeps growing]
> The data only has to be kept for a few days, and generally the system
is
> performing well, but as stated in the email, regular use of vacuumlo,
vacuum
> and autovacuum leaves the OS disc space slowly shrinking.
>
> As a last resort this week,
Nulik Nol wrote:
> I have 2 questions regarding the asynchronous C api (I am using vers.
8.4):
>
> 1) To make a connection in non-blocking manner the api provides PGconn
> *PQconnectStart(const char *conninfo) function. The parameters are
> passed in 'conninfo' variable which is a string so I have
On Dec 21, 2011, at 8:26 AM, Jacques Lamothe wrote:
> Hi, I have 2 cluster databases, running on the same host, Linux with redHat.
> My fist database port is set to default, 5432, but my second database port is
> set to 5436 in the postgresql.conf file. While everything is ok with local
> conn
On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez wrote:
> no when i use /usr/local/var/postgres/pg_log directory show me
> this /usr/local/var/postgres/pg_log/-bash: /usr/local/var/postgres/pg_log/:
> No such file or directory and i use the homebrew installation
>
>
Sorry friend,, am new to homebr
no when i use /usr/local/var/postgres/pg_log directory show me
this /usr/local/var/postgres/pg_log/-bash: /usr/local/var/postgres/pg_log/:
No such file or directory and i use the homebrew installation
El 3 de enero de 2012 02:18, Raghavendra
escribió:
> 2012/1/3 roberto sanchez muñoz
>
>> i trie
On Tue, Jan 3, 2012 at 1:42 AM, Alban Hertroys wrote:
> On 3 Jan 2012, at 5:20, 邓尧 wrote:
>
>> Hi,
>>
>> I'm new to pgsql, I need the do something like the "INSERT IGNORE" in mysql.
>> After some searching I got a solution, which is adding a "do instead
>> nothing" rule to the corresponding tabl
Thank you all for your thoughtful suggestions. I just left for a 5 day East
Coast business trip so I won't have a chance to tackle this gain until the
weekend. For the record, I am running Centos as a VM on both a MAC OS 10.7
laptop and a Windows 7 Workstation. In theory, I ought to be able use
thanks, doesn't stop the server i think i have to reinstall postgresql
2012/1/3 Raghavendra
>
>
> On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez wrote:
>
>> no when i use /usr/local/var/postgres/pg_log directory show me
>> this /usr/local/var/postgres/pg_log/-bash: /usr/local/var/postgres/pg_lo
I'm probably not seeing the obvious so I keep making the same mistake. The
table holds water chemistry data from multiple streams, sites within each
stream, sampling dates, and many chemical constituents.
What I need to do are three things:
1.) Find the date and site for the maximum value
Rich Shepard writes:
>What I need to do are three things:
>1.) Find the date and site for the maximum value of a specified constituent
> on a named stream.
>2.) Find the values of that same constituent at other sites on the named
> stream on that same date.
>3.) Find the date of
Hi,
On 4 January 2012 10:26, Rich Shepard wrote:
> select max(quant), site, sampdate from chemistry where stream = 'SheepCrk'
> and param = 'TDS' group by site, sampdate;
>
> but this gives me the value of each site and date, not the maximum for all
> dates at a specific site. Postgres tells me t
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rich Shepard
Sent: Tuesday, January 03, 2012 6:27 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Single Table Select With Aggregate Function
I'm probably not seei
On Tue, 3 Jan 2012, Tom Lane wrote:
You can do that type of thing using subqueries, eg
select ... from mytab
where col = (select max(col) from mytab where ...)
Thanks, Tom. That's what I thought I needed.
or if you don't mind a nonstandard construct, consider SELECT DIST
On Wed, 4 Jan 2012, Ondrej Ivanič wrote:
window functions might be helpful:
http://www.postgresql.org/docs/9.1/static/tutorial-window.html
Thanks. I'll carefully read this.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
20 matches
Mail list logo
