Hello -
Do you know of a source where I can get a binary of Openssl-1.0.0e for Sparc
64 ( Solaris 10).
Any tips will be very helpful.
Thanks.
Dinesh
Hello -
Do you know of a source where I can get a binary of Openssl-1.0.0e for
Sparc 64 ( Solaris 10).
Any tips will be very helpful.
Thanks.
Dinesh
Hello -
Do you know of a source where I can get a binary of Openssl-1.0.0e for
Sparc 64 ( Solaris 10).
Any tips will be very helpful.
Thanks.
Dinesh
Hello -
We are installing Postgresql-9.1.3 from source against solaris 10, gcc
3.4.6 and it is fails when I enable thread-safety flag.
It install fine if I disable thread-safety flag. One of the options I am
looking into is upgrading gcc. Upgrading Solaris is not an option.
But before I do that
I'd also keep track of tmp directory while building. I hope it is not
creating a huge external sort file. By building you meant to say
pg_restore, I assume.
How big is your maintenance_work_mem? Index creation pools memory from
this buffer.
n Sep 27, 2012 07:01 PM, Greg Williamson
wrote:
>Stev
We had a situation where external sort was creating a humungous temp
file and the space was reclaimed when the process was completed.
Thanks.
Dinesh
On 9/28/2012 8:59 AM, Steve Crawford wrote:
On 09/27/2012 07:01 PM, Greg Williamson wrote:
Steve (and others who replied):
...
The other is a
You might also want to check to see if temp files are growing out of bounds.
Thanks.
Dinesh
On 9/27/2012 3:05 PM, Greg Williamson wrote:
Dear list,
I have a postgres database, 9.1.3, which shows a fairly constant amount of
space used by postgres, but total disk space kees shrinking.
If I resta
one way to get over this issue is to do pg_dump of postgres 8.4 db
using postgres 9.1.2 binaries.
Here is a note from postgres 9.1.2 documentation
"In a default PostgreSQL installation, the handler for the PL/pgSQL
language is built and installed into the "library" directory;
furthermore, the
12 AM, Kevin Grittner wrote:
Dinesh Bhandary wrote:
Has anyone done postgres logical backup (pg_dump) using Amanda (
Advanced Maryland Automatic Network Disk Archiver).
So far I have seen plugin for wall logging method, but have not
found any information on pg_dump.
IMO, there aren't many
Hello,
Has anyone done postgres logical backup (pg_dump) using Amanda (
Advanced Maryland Automatic Network Disk Archiver).
So far I have seen plugin for wall logging method, but have not found
any information on pg_dump. Is it possible to
call a script that does pg_dump and move a dump file to
Hi All -
We have been having some performance issues with indexes right after
truncating a table. My understanding is truncate removes all the
contents of the table and the space get reclaimed immediately.
In such cases what happens to its indexes. It does not seem like they
are removed, but m
We had the same problem, and we still do not have an elegant solution,
we have a workaround which I really don't like.
I agree with Juan - it is a limitation. I understand that you can solve
this problem outside of a database, but it will be nice to have a
strictly read only user who can just
Hi All -
Is there a way to change work_mem for a session in postgres without
restarting a database? Please let me know.
Thanks.
Dinesh
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
dware
> -Disk configuration : RAID5 (MegaCLI)
> -CPU : Xeon2.4
>
> Thank you.
You haven't really provided us with much detail here, but it kind of
sounds like your system is overloaded.
...Robert
On 5/4/2011 2:55 PM, Dinesh Bhandary wrote:
Hi All -
I
Hi All -
I am getting the following error while starting postgres 9.0.3. And when
it happens I could not establish new connections and the following error
messages keeps on coming up.
Are you guys aware of this problem? Is it a bug? It has happened to me
twice already. We are running this on r
can hide
connection details from a user if we use dblink? I just want to make
sure this read only
user does not go and query our system catalogs in production server.
Dblink should be easier to implement than using replication tool.
Thanks.
Dinesh
On 3/9/2011 4:24 PM, Dinesh Bhandary wrote
Hi All -
Please let me know if this is possible to do in postgres.
I am creating a read only user, which has limited access to db objects,
primarily views. Even though this user can't query data from other db
objects it can view the system catalog using pg* views and tables,
thereby exposing
Hi All - Is log_file_mode parameter available for postgres 9.0 only? Ran
into a bit of problems with log permission and came across a new GUC
"log_file_mode". But I could not seem to find much docs on it and I am
not sure if it is production ready.
Can patches be applied to older version of post
I've used eclipse with clay (plugin) in the past and it is good. It is
free.
Dinesh
On Nov 12, 2010 06:46 AM, Thomas Kellerer wrote:
>Lou Picciano, 12.11.2010 15:40:
>>Friends,
>>
>>This question from our users keeps coming up...
>>
>>What tools are each of you using for ERD ERM? pgAmin's Gra
Hi All -
I am working to tune the auto vacuum in 8.4 and 8.2. I am finding that
some of the tables are not getting vacuumed even though they exceed
analyze/vacuum threshold. Do you know where auto vacuum process looks to
get the number of rows deleted/updated/inserted?
pg_stat_user_tables have
I've used eclipse with clay ( plugin) in the past, it is pretty good.
And it is free,.
Dinesh
On 11/12/2010 8:07 AM, Mark Felder wrote:
On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano
wrote:
What tools are each of you using for ERD ERM? pgAmin's Graphical
Query Builder is helpful, but do
Hi All -
We run both postgres 8.2.3 and 8.4.1 in unix environment. We have auto
vacuum configured and I am trying to find out its effectiveness. Here
are a couple of questions:
1) I'm running a query that compares actual table count with the pg_stat
table count ( pg_stat_user_tables.n_live_
I've heard that rubyrep (http://www.rubyrep.org) is a good tool for
replication too. I think it has gained popularity because of its ease of
use.
On a similar note I am eager to try postgreSQl 9.0 bulit in hot standby
solution.I can't really wait till Postgersql rolls out replicated
solution
HI All,
I feel like I am in a very weird situation. I took a postgres dump
because db was bloated and in the process of restoring it and running
into several issues.
I run postgres 8.4.1 on red hat.
Here is what id did.
1) pg_dump
2) drop db
3) pg_restore on the same cluster ( where there a
Awesome, this will work. It won't retain the column name in insert
into statement. I was not sure if this will work with postgres 8.2.5 but
it does.
Thanks.
Dinesh
On 10/5/2010 11:15 AM, Kevin Grittner wrote:
Dinesh Bhandary wrote:
Is there an easy way to restore to a new table wher
Hi All,
Is there an easy way to restore to a new table where the column name
have been changed but data remains the same?
For example I am trying to restore from existing system, table1(col1)
to table1(col2) and it is erroring out on the new column name even
though it is a data only restore.
9/17/2010 8:32 PM, Greg Smith wrote:
Dinesh Bhandary wrote:
Due to hardware crash we ran into issues where some blocks were
corrupted and some files were missing.
I was able to get over the corrupted blocks ( errmsg - "invalid page
header in block 12345 of realtion x") by setting
zero_
Hello Everybody -
Due to hardware crash we ran into issues where some blocks were
corrupted and some files were missing.
I was able to get over the corrupted blocks ( errmsg - "invalid page
header in block 12345 of realtion x") by setting
zero_damaged_pages=0 and running vacuum afterwards. No
28 matches
Mail list logo
