Hi.
Upon rebooting one of our main production database servers, we were
greeted with this:
(@)<2006-03-18 23:30:32.687 MST>[3791]LOG: database system was
interrupted while in recovery at 2006-03-18 23:30:26 MST
(@)<2006-03-18 23:30:32.687 MST>[3791]HINT: This probably means that
some data is co
Title: Message
Hello!
I need to load a
pgsql 8.1 database dump (SQL format) into a pgsql 7.3 server (through
phpPgAdmin). This does not work, since many v8 instructions are not recognised
by v7.3 (e.g. SET default_table_space, function pg_get_serial_sequence,...)
which is not unexpected.
Title: RE: Postgresql over ppc4 °
_
De: Ivan Israel Azuara Hernandez
Enviado el: Viernes, 17 de Marzo de 2006 09:26 p.m.
Para: 'pgsql-general@postgresql.org'
CC: Ivan Israel Azuara Hernandez
Asunto: Postgresql over ppc4 °
Im
I'm facing an issue with PostgreSQL .. The server seems to drop the
connection to my script after a couple of hours (sometimes, not always).
DBD::Pg::db selectrow_array failed: could not receive data from server:
:server closed the connection unexpectedly.
And in another scenario it f
Title: Postgresql over ppc4 °
Hi.
Where can i download the postgresql-7.4-3 release for ppc64 ?. What postgresql release is compatible for this kind of arquitecture ?.
My server is a pseries p520/power 5/64 bits.
Thank's in advance !
Ivan Azuara
Thanks Martijn.
\d test
Table "public.test"
Column | Type | Modifiers
id | integer |
score| integer |
I tried \copy test (score) to test.txt. It works well.
But, suppose I want to select rows with score > 20 (just an example).
Then,\copy table [ ( column_list ) ] { from
On Saturday 18 March 2006 01:38 pm, Hrishikesh Deshmukh wrote:
> The README doesn't talk about what next to do after installation from rpms,
> there is no file which talks about in the
> /usr/share/doc/packages/postgresql . It only says look at INSTALL file but
> there is no install with the rpms!!
Andrus Moor wrote:
> I found that \ characters needs not to be quoted in password strings
>
> create role test1 password '\'
>
> is OK.
Not sure what client you are using but in psql this fails to find the
ending quote, as it should.
-
Jojo Paderes wrote:
We're currently using Ubuntu Breezy Hedgehog for our existing
PostgreSQL database server (8.0.x). A Java-based applications uses the
database server via JDBC.
I'm not sure if this question is within the context but I would like
to know if clustering can provide a hot-standby
I found that \ characters needs not to be quoted in password strings
create role test1 password '\'
is OK.
I havent found any mention of this behaviour in docs.
Where this is documented ?
I created role
create role test2 password
Trying to login using password ' causes error from my ODB
The README doesn't talk about what next to do after installation from
rpms, there is no file which talks about in the
/usr/share/doc/packages/postgresql . It only says look at INSTALL file
but there is no install with the rpms!!
Thanks,
HrishiOn 3/18/06, Adrian Klaver <[EMAIL PROTECTED]> wrote:
On
On Saturday 18 March 2006 11:44 am, Hrishikesh Deshmukh wrote:
> Hi All,
>
> In downloaded the rpms and installed rpms.
> Could someone help me what to do next?!
> The 8.0 documentation talks about installation from source code!
>
> Thanks,
> Hrishi
SuSE puts their documentation for packages under
Hi All,
In downloaded the rpms and installed rpms.
Could someone help me what to do next?!
The 8.0 documentation talks about installation from source code!
Thanks,
Hrishi
On Saturday 18 March 2006 12:58, Florian G. Pflug wrote:
> Kevin Brown wrote:
> > So what you're saying is that my commits and rollbacks should be async,
> > correct?
>
> No, you should always use _async(), and never, ever use query() or exec()
> in a multi-threaded app.
>
> > I don't quite underst
Kevin Brown wrote:
On Saturday 18 March 2006 12:31, Florian G. Pflug wrote:
I've been creating a databased application with PostgreSQL for a while
now and have loved it, though we just recently stumbled on an interesting
bug.
I have a particular dialog which can do all kinds of incredibly
compl
On Saturday 18 March 2006 12:31, Florian G. Pflug wrote:
> Kevin Brown wrote:
> > I've been creating a databased application with PostgreSQL for a while
> > now and have loved it, though we just recently stumbled on an interesting
> > bug.
> >
> > I have a particular dialog which can do all kinds o
Kevin Brown wrote:
I've been creating a databased application with PostgreSQL for a while now and
have loved it, though we just recently stumbled on an interesting bug.
I have a particular dialog which can do all kinds of incredibly complicated
things to the database. Of course I didn't want
On Saturday 18 March 2006 09:15 am, Hrishikesh Deshmukh wrote:
> Hi All,
>
> Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> 10.0?
>
> Sincerely,
> Hrishi
Try this site and enter postgresql. I found rpm's for OpenSuSE .
http://rpm.pbone.net/index.php3
--
Adrian Klaver
Hi All,Can somebody please tell me where i can find rpms for postgesql on OpenSuse 10.0?Sincerely,Hrishi
Heck, I forgot version information:
rnd=# select version();
version
--
PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
Hello List:
I'm having an "interesting" problem. I know what is happening, but I do not
know why; therefore, I am hoping that some of those very familiar with the
internals can/will explain it to me.
I have a function A written in plpgsql which is designed to undo changes to
several records. T
21 matches
Mail list logo
