Greg Smith píše v ne 15. 11. 2009 v 22:16 -0500:
> Tom Lane wrote:
> > Simon Riggs writes:
> >
> > > If we did add an extra option then the option would be "initdb" not
> > > "init". It would take us all years to remove all evidence of the phrase
> > > "initdb" from the mailing lists and our m
Tom Lane píše v so 14. 11. 2009 v 11:22 -0500:
> Zdenek Kotala writes:
> > Because there is doubt if someone else want this I would like to ask
> > here for your opinion. There are following options:
>
> > 1) Yeah I like pg_ctl init
>
> > "pg_c
Hi all,
I prepared patch which extend pg_ctl functionality and add "init"
command which do same thing like initdb (it calls initdb on the
background). The idea behind this is to have only one command which
control database. pg_ctl already has "start", "stop", "restart",
"reload" and so on. To have
John R Pierce píše v so 26. 09. 2009 v 10:57 -0700:
> Zdenek Kotala wrote:
> >> I asked because we're working on an inhouse app using postgres, the team
> >> wants to use 8.4... I had previously packaged 8.3.7 in solaris package
> >> format only to have it
John R Pierce píše v so 26. 09. 2009 v 09:44 -0700:
> >> I'm curious if anyone has a clue how long before Sun releases PG 8.4.x
> >> in Solaris 'patch' format ...
> >>
> >
> > Currently S10 is shipped with three version (8.1, 8.2, 8.3) of
> > PostgreSQL. There is no plan to integrate PG8.4
John R Pierce píše v út 15. 09. 2009 v 19:53 -0700:
> anyone on the PG team privvy to Sun Solaris patches for postgres? like
> patch 138826-04 is Postgres 8.3.7 for Solaris10 Sparc... 138827-04 is
> the same for Sol10 x86...
What is wrong on this? It is standard Solaris way how to deliver
VANOLE, MICHAEL J (ATTSI) píše v pá 11. 09. 2009 v 11:58 -0500:
> Hi,
>
> We are running Pg 8.2.6 on sparc-sun-solaris2.9 compiled by gcc 3.4.6.
>
> We are planning a server software upgrade to Solaris 10 (binaries and
> kernel, etc).
>
> Has anyone done this, and were there problems when tryi
plain some steps to run with SSL.
2008/11/1, Zdenek Kotala <[EMAIL PROTECTED]>:
Hi,
It is really strange. Is there any reason why you don't use integrated SSL?
64bit version is located in /usr/sfw/lib/64
Try
./configure --prefix=/opt/usr/local
--with-libs=/usr/sfw/lib/64:/opt/usr/local
s expected.
any thoughts?
thanks in advance.
dotyet
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
look on original Makefile for solaris fro inspiration:
http://src.opensolaris.org/source/xref/sfw/usr/src/cmd/postgres/postgresql-8.3/
http://src.opensolaris.org/source/xref/sfw/usr/src/cmd/postgres/postgresql-8.3/Makefile.sfw
Zdenek
--
Zdenek Kotala Sun
Randal T. Rioux napsal(a):
On Wed, September 10, 2008 10:54 am, Zdenek Kotala wrote:
I just don't like the Solaris package system in general. It is, dare I
say, worse than RPM. But this is a PostgreSQL list, so I'll save the rant!
Community solaris "package" on postgre
Randal T. Rioux napsal(a):
On Tue, September 9, 2008 5:25 am, Zdenek Kotala wrote:
Randal T. Rioux napsal(a):
I've battled this for a while. I'm finally breaking down and asking for
help.
If you're answer to this is "why 64-bit" then don't answer. You wouldn'
Markova, Nina napsal(a):
Hi,
I am working on installing postgres ina zone - zoneadm install command
finished with errors :
Error: /usr/lib/libkrb5.so.1 not found.
Please install the patch for 6381288 (we should expose the krb5 api).
The patch needed is 125077-02 for SPARC and 125078-02 for x8
Randal T. Rioux napsal(a):
I've battled this for a while. I'm finally breaking down and asking for help.
If you're answer to this is "why 64-bit" then don't answer. You wouldn't
understand. Same if you say "why don't you use packages."
Here is my scenerio:
- Sun 420R x450Mhz UltraSPARC-II / 4
Tom Lane napsal(a):
I'm not a Solaris user
I can sent you a installation media ;-), if you want.
, but I'd be kinda surprised if Solaris' own
libraries were built with gcc --- Sun has their own compiler no?
Yes, sun studio. It is not installed by default, but it is possible to
download i
David Harel napsal(a):
Hi,
I'm new here. I work on a site that uses postgres version 8.1.5 and
database encoding ISO_8859_8. When I sort select requests using order by
the "weight" of the characters seem to be really funny (but consistent).
It seems to me that if I create a "phantom" converte
Do you have any core dump? Stack trace should help.
Zdenek
A B napsal(a):
I get a lot of
Error server closed the connection unexpectedly This probably means
the server terminated abnormally before or while processing the
request.
and I think I need some help finding out what is the pr
Gurjeet Singh napsal(a):
The query should be
select * from pg_class where relfienode = 58374
Yeah, of course. Thanks
Zdenek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-g
Q Master napsal(a):
I get this strange error
Caused by: org.postgresql.util.PSQLException: ERROR: could not open
relation 1663/53544/58374: No such file or directory
How do I recover from it ? Version 8.2 on windows.
I think I had an hardware issue in the past where my box rebooted few
time
Richard Huxton napsal(a):
I think someone is looking at per-database locales for 8.4 - the issue
is more tricky than you might think because you need to worry about
system catalogue sort-order.
There is Google Soc project for implementing collation per database level. I
hope it will appear
Roberts, Jon napsal(a):
I don't see a pljava file in my share directory like I do on Windows.
Is pl/java not included when compiling from source?
pl/java is not part of core like pl/pgPerl... You need to download it separately
from http://pgfoundry.org/projects/pljava/
Zden
Mikko Partio napsal(a):
On Tue, Apr 8, 2008 at 5:26 PM, Mikko Partio <[EMAIL PROTECTED]> wrote:
Ok I removed the faulty tuple and nothing catastrophical happened. I can
do a pg_dump now, but I still can't remove the one remaining table:
# drop table xyz ;
ERROR: too many trigger records found
Mikko Partio napsal(a):
How can I tell if there is clog corruption?
Unfortunatelly, I'm afraid that there is not way how to check it. CLOG file is
only array of bits and it does not contains any CRC or backup copy. Try to check
filesystem integrity.
Zdenek
--
Sent via pgsql-gene
Mikko Partio napsal(a):
On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <[EMAIL PROTECTED]> wrote:
Mikko Partio napsal(a):
Should I try remove one of the duplicate rows from pg_class?
Try it with caution. You should use ctid column to refer to exact row.
Try before:
select oid, ctid
Mikko Partio napsal(a):
Should I try remove one of the duplicate rows from pg_class?
Try it with caution. You should use ctid column to refer to exact row.
Try before:
select oid, ctid, xmin, xmax, cmin, cmax, relname from pg_class where oid =
294397;
If both row are identical or not.
Mikko Partio napsal(a):
I little investigation showed that there is duplicate row in pg_class:
# select oid from pg_class group by oid having count(*) > 1 ;
oid
294397
(1 row)
Could you check if pg_attribute is doubled for this relation?
Zdenek
--
Sent via pgsql
Mikko Partio napsal(a):
Hello all
Postgres version 8.3.1
I just created a bunch of tables (~10) with identical structure; all tables
have 6 foreign key references to other tables and a primary key. To my
surprise, some of the tables were created ok, some missed primary key and
some didn't get
Morris Goldstein napsal(a):
But that makes me wonder: what about this sequence of events:
- Postgres running normally on /dev/sda and /dev/sdb.
- Update to table in /dev/sdb tablespace is committed but still exists in WAL.
- Postgres crashes (e.g. power failure).
- Postgres starts with /dev/sda
Morris Goldstein napsal(a):
Suppose I have a database with $PGDATA on /dev/sda, and a tablespace
directory on /dev/sdb. Will Postgres start successfully if /dev/sda is
mounted and /dev/sdb is not? If not, why not?
It is not good idea to run PostgreSQL in your scenario. However PostgeSQL needs
PG 8.3 has strict rule what CTYPE and LOCALLE is allowed. It is protection
before possible problems with data processing. You probably need set en_AU.uft8
locale when you initialize server.
Zdenek
Naz Gassiep napsal(a):
I have just attempted to upgrade to 8.3.1 and I now get t
Greg Sabino Mullane napsal(a):
Nobody want to rename psql. Personaly, I dislike current command
names for long long time. Many times I tried create unix user by
createuser command. And these names could be potential names of
system commands.
Yours is the first time I've heard of anyone with
Naz Gassiep napsal(a):
We're not seriously thinking of changing these are we? Once a command
set has been in use for as long a time as the PG command set has, any
benefit that may be derived by new users with an aversion to
documentation reading is vastly offset by the confusion that would
Tom Lane napsal(a):
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I like this too. It'd be considerably more work than the currently
proposed patch, though, since we'd have to meld the currently
separate programs into one executable.
I note that we can continue to have the curr
Alvaro Herrera napsal(a):
Zdenek Kotala wrote:
And what about two commands one for create and one for drop?
It save 6 or 4 chars.
pgc db (as create db)
pgc user
pgd db (as drop db)
pgd user
Well, there are things besides create and drop -- for example vacuum.
Yeah, good point I forgot
Alvaro Herrera napsal(a):
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Greg Smith wrote:
And if anybody suggests putting a "_" in something I have to type all the
time, I will stick my fingers in my ears and start yelling until they
stop. Bad enough I have to type pg_ctl a few
Alvaro Herrera napsal(a):
Tom Lane wrote:
"Leif B. Kristensen" <[EMAIL PROTECTED]> writes:
On Wednesday 26. March 2008, Ron Mayer wrote:
I'd prefer a "pg" program that took as arguments
the command. So you'd have "pg createdb" instead
of "pg_createdb".
I'll second that. It would be much easie
Ron Mayer napsal(a):
Zdeněk Kotala wrote:
1) What type of names do you prefer?
I'd prefer a "pg" program that took as arguments
the command. So you'd have "pg createdb" instead
of "pg_createdb".
There are many precedents. "cvs update", "git pull"
"apt-get install".
Anyone else like this ap
Tom Lane napsal(a):
"Leif B. Kristensen" <[EMAIL PROTECTED]> writes:
On Wednesday 26. March 2008, Ron Mayer wrote:
I'd prefer a "pg" program that took as arguments
the command. So you'd have "pg createdb" instead
of "pg_createdb".
I'll second that. It would be much easier on the brain, as yo
Ron Mayer napsal(a):
Tom Lane wrote:
"Leif B. Kristensen" <[EMAIL PROTECTED]> writes:
On Wednesday 26. March 2008, Ron Mayer wrote:
...a "pg" program that took as arguments
the command. So you'd have "pg createdb" instead
of "pg_createdb".
I'll second that. ...
I like this too.
Though
LARC/J.L.Shipman/jshipman napsal(a):
Hello,
I am running postgresql 8.2.5 on Solaris 10. When I try to shut
down postgres using
pg_ctrl -D datafile stop
it does not shutdown.Does anyone know why this is, or what files
pg_ctrl access to determine
the shutdown process. We have tried
40 matches
Mail list logo