On Feb 8, 2008 5:54 PM, Kasia Tuszynska <[EMAIL PROTECTED]> wrote:
> Hello Everybody,
>
> I would like to install Postgresql 8.2.4 or Postgresql 8.3 on both
> solaris 10 and suse10.
Sun makes packages of postgresql available. Do a search for
postgresql on the sun.com site. Last I checked it was
Hello Everybody,
I would like to install Postgresql 8.2.4 or Postgresql 8.3 on both
solaris 10 and suse10.
On the postgres site I found rpms to install on red hat and fedora, but
not for the os' above.
Does that mean that in order to install on either solaris or suse I :
1. need to install from s
On Feb 7, 2008 11:27 PM, Vishal Arora <[EMAIL PROTECTED]> wrote:
> You can have more than one instance of PostgreSQL server running on the same
> Windows machine as long as you have different DataDir for each of them. you
> can have initdb process indicating different datadir.
And you need each in
"Mark Steben" <[EMAIL PROTECTED]> writes:
> The doc says to do an initdb and reload the data whenever you run
> pg_resetxlog. Do you concur with that even if we are only resetting the OID
> counter?
The docs are thinking of the case where you are trying to recover from
database corruption. If yo
On Fri, Feb 08, 2008 at 06:30:33PM +, [EMAIL PROTECTED] wrote:
>
> LOG unexpected EOF on client connection
> LOG unexpected EOF on client connection
> LOG unexpected EOF on client connection
This means the back end thinks the client disappeared.
What is the probability you have a firewall
I pulled up another instance of pgadmin to take a look since the initial
instance gave me the windows "not responding" message on the title bar.
In the server status log file I see the following lines right about where my
disk and cpu
activity stops and my backup seems to hang. There are no ot
On Feb 8, 2008 1:37 PM, Mark Steben <[EMAIL PROTECTED]> wrote:
> The doc says to do an initdb and reload the data whenever you run
> pg_resetxlog. Do you concur with that even if we are only resetting the OID
> counter?
On 7.4 I'd say you'd be better off dumping and reloading all your data
than p
The doc says to do an initdb and reload the data whenever you run
pg_resetxlog. Do you concur with that even if we are only resetting the OID
counter?
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, February 08, 2008 11:36 AM
To: Mark Steben
Cc: pgsql-admin@post
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> Postgres backsup the data and 95% of the time sticks at this table and cpu
> activity drops from 40-60% to about zero. I can stay there for hours before
> I just have to stop the attempt.
Have you looked into pg_locks to see if something is ho
"Mark Steben" <[EMAIL PROTECTED]> writes:
> The number may change pointing to another index or stay the same.
> The error persists if I repeat 3 or 4 times. Usually after the
> 4th or 5th time the cluster is successful.
Hm. I'd guess that the installation is old enough that the OID counter
has w
I am using postgres 8.2.6 on windows xp pro sp2. Of about 80 tables, one is a
large binary table containing over 2gb of data.
Postgres backsup the data and 95% of the time sticks at this table and cpu
activity drops from 40-60% to about zero. I can stay there for hours before I
just have to s
Bruce Momjian escribió:
> The release note item says we can now reclaim without vacuum:
>
>"UPDATE"s and "DELETE"s leave dead tuples behind, as do failed
>"INSERT"s. Previously only "VACUUM" could reclaim
>space taken by dead tuples. With HOT dead tuple space can be
>
The number may change pointing to another index or stay the same.
The error persists if I repeat 3 or 4 times. Usually after the
4th or 5th time the cluster is successful.
What is the risk of performing an upgrade to 7.4.19?
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Se
"Mark Steben" <[EMAIL PROTECTED]> writes:
> I am getting the following error when I attempt to CLUSTER on a table:
> mavmail=# cluster mailer_queue;
> ERROR: could not create relation "pg_temp_752992924": File exists
If you repeat the command, does the error persist? Does the number
stay the sa
Chris Hoover wrote:
> On Feb 7, 2008 6:48 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> > Bruce Momjian escribi?:
> > > Dimitri Fontaine wrote:
> >
> > > > What about Alvaro's concern about manual vacuuming policies editing
> > wrt to
> > > > HOT?
> > >
> > > I think most people will be using
Alvaro Herrera wrote:
> Bruce Momjian escribi?:
> > Dimitri Fontaine wrote:
>
> > > What about Alvaro's concern about manual vacuuming policies editing wrt
> > > to
> > > HOT?
> >
> > I think most people will be using autovacuum, and those who aren't will
> > have to realize that HOT makes vacu
Hello listers,
I am getting the following error when I attempt to CLUSTER on a table:
mavmail=# cluster mailer_queue;
ERROR: could not create relation "pg_temp_752992924": File exists
The 752992924 is the oid of one of the indexes of this table (not the
clustering index)
This app
Linux is sensitive to uppercase or lowercase
make sure your script has all the tables names as they are shown in postgresql
su - postgres
\d
check all the names
I ran into that problem awhile ago..
Date: Fri, 8 Feb 2008 18:47:02 +0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re:
Στις Friday 08 February 2008 00:35:52 ο/η PostgreSql έγραψε:
> Hi
> My application runs fine on Windows.
> However when I copy the files to the Linux server some queries return no
> results or errors even though the records and tables exist!
> It is always the same records or tables that are not f
On Feb 8, 2008 3:35 AM, PostgreSql <[EMAIL PROTECTED]> wrote:
> Hi
> My application runs fine on Windows.
> However when I copy the files to the Linux server some queries return no
> results or errors even though the records and tables exist!
> It is always the same records or tables that are not
Hi
My application runs fine on Windows.
However when I copy the files to the Linux server some queries return no
results or errors even though the records and tables exist!
It is always the same records or tables that are not found!
In case of a table the error is: function.pg-query: Query failed:
On Feb 7, 2008 6:48 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Bruce Momjian escribió:
> > Dimitri Fontaine wrote:
>
> > > What about Alvaro's concern about manual vacuuming policies editing
> wrt to
> > > HOT?
> >
> > I think most people will be using autovacuum, and those who aren't will
>
On 06.02-12:40, Bhella Paramjeet-PFCW67 wrote:
> [ ... ]
> > We are considering having postgres 8.2 on solaris 10 machine for our
> > production environment. While reading through sun docs, it looks like
> > the solaris 10 update 6 onwards comes with the postgres 8.2 installed
> > under /usr/pos
> From: [EMAIL PROTECTED]> To: pgsql-admin@postgresql.org> Date: Fri, 8 Feb
> 2008 09:04:46 +0100> Subject: [ADMIN] Pg_dump and password> > Hi Folks!> > Is
> it possible to call pg_dump not only with -U username but also with the
> user's password?
Yes you can use -W option along with -U o
Achilleas Mantzios написа:
Στις Friday 08 February 2008 10:04:46 ο/η Pleyer, Walter έγραψε:
Hi Folks!
Is it possible to call pg_dump not only with -U username but also with the
user's password?
No, you should use the PGPASSWORD env variable.
Walter
Actually the recommended method for pass
Στις Friday 08 February 2008 10:04:46 ο/η Pleyer, Walter έγραψε:
> Hi Folks!
>
> Is it possible to call pg_dump not only with -U username but also with the
> user's password?
No, you should use the PGPASSWORD env variable.
>
> Walter
>
>
>
>
> ---(end of broadcast)--
Hi Folks!
Is it possible to call pg_dump not only with -U username but also with the
user's password?
Walter
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
27 matches
Mail list logo
