--- On Tue, 3/15/11, H S aras_h1...@yahoo.com wrote:
From: H S aras_h1...@yahoo.com
Subject: Re: [ADMIN] createdb does not work?!
To: dhaval jaiswal dhava...@hotmail.com
Date: Tuesday, March 15, 2011, 9:31 AM
in one terminal I have recieved this notes:
LOG: database system was shut down at
Clearly it's trying to use an OID it calculated for one of these
tables after the table has been dropped, and I suspect that the lock
is released between gathering the data and sorting it. I don't have
any 8.2 databases around to try this on, but perhaps you would avoid
it with a slight
Hi all -
Ever since daylight savings time, I've noticed that the timestamp in the
log files on 2 of our many postgres servers (version 8.4.5) did not
update. It's still 1 hour behind. The settings are all default (see
below) on all the servers.
# - Locale and Formatting -
datestyle =
Gnanakumar gna...@zoniac.com wrote:
If that doesn't do it I might try adding zero to numbers and
concatenating empty strings to try to prevent late use of the
OID. (Essentially as a form of optimization barrier.)
I couldn't understand this approach clearly. Can you help explain
me with
On Tue, Mar 15, 2011 at 6:50 AM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
Hi all -
Ever since daylight savings time, I've noticed that the timestamp in the log
files on 2 of our many postgres servers (version 8.4.5) did not update.
It's still 1 hour behind. The settings are all
On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
when you say updating postgres - do you mean the server software? How do
you update the tz data?
Yes updating the pg software. The OS has tzdata as well, and you can
update that. But postgresql includes its own
On Tue, Mar 15, 2011 at 12:17 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
when you say updating postgres - do you mean the server software? How do
you update the tz data?
Yes updating the pg software.
yes they are all running the same postgres version. - 8.4.5
just as a test this morning - on one of the problem machines, we
installed another postgres installation - same version - just pointed it
to different paths - copied over the conf files and brought the server
up. This time it was
it also looks like the view pg_timezone_names is empty in the problem
installation. What loads this view?
psql (8.4.5)
Type help for help.
postgres=# select * from pg_timezone_names;
name | abbrev | utc_offset | is_dst
--+++
(0 rows)
postgres=#
On 3/15/11
when you say updating postgres - do you mean the server software? How
do you update the tz data?
I'm just a little concerned why only 2 of our machines (they are all
supposed to be the same) are having this problem.
On 3/15/11 2:08 PM, Scott Marlowe wrote:
On Tue, Mar 15, 2011 at 6:50 AM,
Maria L. Wilson maria.l.wilso...@nasa.gov writes:
yes they are all running the same postgres version. - 8.4.5
just as a test this morning - on one of the problem machines, we
installed another postgres installation - same version - just pointed it
to different paths - copied over the conf
I would have thought the same thing too - but, the file system looks
correct.(below...)
[postgres@catalogdata share]$ cd timezone
/scratch/postgresql-8.4.5/share/timezone
[postgres@catalogdata timezone]$ ls -al
total 268
drwxr-xr-x 19 root staff 4096 Nov 1 09:08 ./
drwxr-xr-x 9 root
Maria L. Wilson maria.l.wilso...@nasa.gov writes:
I would have thought the same thing too - but, the file system looks
correct.(below...)
-rw--- 3 root staff 3519 Nov 1 09:08 Eastern
Well ... correct other than lacking read permissions for anybody but
root ...
good grief! - thanks for seeing that.
ok, next question. so I change these permissions (to the correct read
perms :)
then how does postgres load these timezone? I'm really hoping that
this doesn't require a re-install.
thanks again!! Maria Wilson
On 3/15/11 4:12 PM, Tom Lane wrote:
Maria L. Wilson wrote:
good grief! - thanks for seeing that.
ok, next question. so I change these permissions (to the correct read
perms :)
then how does postgres load these timezone? I'm really hoping that
this doesn't require a re-install.
Restarting the server will fix it. I
Using PostgreSQL 9.0.x
I cannot use pg_dump to generate a backup of a database on a hot-
standby server, because it is, by definition, read-only. However, it
seems that I can use COPY TO within a serializable transaction to
create a consistent set of data file(s). For example,
BEGIN
Stephen Rees sr...@pandora.com wrote:
I cannot use pg_dump to generate a backup of a database on a hot-
standby server, because it is, by definition, read-only.
That seems like a non sequitur -- I didn't think pg_dump wrote
anything to the source database. Have you actually tried? If so,
On Tue, Mar 15, 2011 at 5:50 PM, Stephen Rees sr...@pandora.com wrote:
Using PostgreSQL 9.0.x
I cannot use pg_dump to generate a backup of a database on a hot-standby
server, because it is, by definition, read-only.
That really makes no sense :-) You can use pg_dump on a read-only
slave, but
Greetings!
We are running multiple clusters for development and test purposes. I was
experimenting, as a PostgreSQL newbie, with upgrading from v9.0.1 to v9.0.2.
I noticed that the installation of v9.0.2 did upgrade the default (original)
cluster as part of the process.
When I start the
On Sun, Mar 13, 2011 at 3:54 AM, Rosser Schwarz
rosser.schw...@gmail.com wrote:
On Sat, Mar 12, 2011 at 11:46 AM, Bruce Momjian br...@momjian.us wrote:
Benjamin Krajmalnik wrote:
Has anyone heard from the Japanese members of the community?
Yes, I posted a list of Japan members who have
20 matches
Mail list logo