Maybe "test" is a reserved word.
Try test1.
From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on
behalf of Dale Gallagher [dale.gallag...@gmail.com]
Sent: Monday, May 31, 2010 3:50 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN]
All,
How does one tell how much space is available (probably by table), after
a
"vacuum verbose analyze" has completed. As I understand it, the emptied
space will still be only available to the table that originally housed
it.
We are running Postgresql 8.3 in various Solaris and Linux envir
r vacuuming everything on a reasonable schedule.
>> That includes the system catalogs. I think you'd be better off taking
>> the effort to learn to tune autovacuum to fit your requirements.
>>
>>regards, tom lane
>>
>
tions.
regards, tom lane
--
Naomi Walker Chief Information Officer
Eldorado Computing, Inc nwal...@eldocomp.com
---An EDS Company 602-604
just won't start up.
--
----
Naomi Walker Chief Information Officer
Eldorado Computing, Inc nwal...@eldocomp.com
---An EDS Company
at were deleted from the file and write them back into the
table. Is there a way to retrieve the data from
the pg_xlog?
This is a server running x86 Solaris 10, postgres 8.2.4.
Naomi
--
--------
Naomi Walker
back into the
table. Is there a way to retrieve the data from
the pg_xlog?
This is a server running x86 Solaris 10, postgres 8.2.4.
Naomi
--
Naomi Walker Chief Information Officer
Eldorado
04.3100 x265
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Grittner
> Sent: Tuesday, July 01, 2008 2:23 PM
> To: Naomi Walker; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Change a character in a text field
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Grittner
Sent: Tuesday, July 01, 2008 2:23 PM
To: Naomi Walker; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Change a character in a text field
Naomi Walker <[EMAIL PROTECTED]> wrote:
Is there so
do it in place..
Thanks,
Naomi
--
--------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc [EMAIL PROTECTED]
---An EDS Company
8.2.6
on Solaris 9]
Karen Stone
Technical Services
MphasiS Health Solutions
602.604.3100 x265
--
Naomi Walker Chief Information Officer
Eldorado Computing, Inc [EMAIL
tiality or privilege. Use of this email is
> prohibited when received in error.
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archive
8.1/static/monitoring.html
>
> On Solaris, note the Tip at the bottom (not sure if it applies to recent
> Solaris versions but a few years ago it was critical).
>
> regards, tom lane
>
--
-------
I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris
10 OS), but someone is connected to
the database. What is the best way to find out exactly who is connected?
Thanks,
Naomi
--
Naomi W
I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris
10 OS), but someone is connected to
the database. What is the best way to find out exactly who is connected?
Thanks,
Naomi
--
Naomi W
/ - Tag - Search - Share
>
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>
gt;> regards, tom lane
>>
>> ---(end of broadcast)---
>> TIP 6: explain analyze is your friend
>>
>>
>
>
>
> ---(end of broadcast)---
> TIP 5: don't forget to i
s e-mail message including any attachment
> may contain
> confidential, proprietary or legally privileged information.
> It should not
> be used by who is not the original intended recipient. If you have
> erroneously receive
x backup,
>>> using
>>> their respective native file system? What are the minimal conditions
>>> to be
>>> met?
>>
>> No the data is not only dependent on the platform, but also on the
>> configure
>> options used for the build.
>
consider adding
such a utility or adding
this to pg_dump?
Naomi
--
--------
Naomi Walker Chief Information Officer
Mphasis Healthcare Solutions [EMAIL PROTECTED]
---An EDS Company
t
> understand it. This is fixed in HEAD (by using appendStringLiteralConn)
> but I'm not sure if there is any very good way to fix it in the back
> branches.
>
> In the short term, Naomi's best workaround is surely to drop or rename
> that user ... it hardly seems l
shadow WHERE usename =
E'\003'
--
--------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100
--
--(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
--
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100
d data out of the tables using your knowledge of
> the mail store. That way you'll not need to have such a long running
> backup and it won't be so large either. You can then reassemble the
> pieces later into a new table in case of recovery.
>
--
---
hines, but also plan to use x86 Solaris
9 on an commidity server.
Naomi
--
---------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. nw
s I said the other day, this is recreating a test db from the
> production one as part of unit tests, so this happens dozens of times a day...
>
>
--
-
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. nwa
get off all lists at once with the unregister command
>(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
-
Naomi Walker Chief
up, can you please clarify exactly what on-the-wire means?
--
-----
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. [EMAIL PROTE
enable locale in compile, remove --enable-locale
option
>
>
--
-
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. [EMAIL PROTECTED] 602-60
We are looking at enabling LOCALE, on 7.3.4 and 7.4.3 Postgres
installations, yet LOCALE is not listed under the options to enable.
Anyone know?
Naomi Walker wrote:
>We are seeing some different sorting sequences (when using BETWEEN)
>amoung our various operating systems. My guess i
--
-
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. [EMAIL PROTECTED] 602-604-3100
-
Freedom is not
-- CONFIDENTIALITY NOTICE --
This
message is intended for the sole use of the individual and entity to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the intended
addressee, nor authorized t
-- CONFIDENTIALITY NOTICE --
This
message is intended for the sole use of the individual and entity to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the intended
addressee, nor authorized t
Frederic Massot wrote:
> Hi,
>
> How can I know the size of the database on a server Postgresql 7.3.4 ?
>
> Regards.
try contrib/dbsize
Its a bit of a pain, but better than nothing.
--
-------
deric Massot wrote:
> Hi,
>
> How can I know the size of the database on a server Postgresql 7.3.4 ?
>
> Regards.
--
---------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc.
ur
> joining column's datatypes do not match
>
>
>
--
-----
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. [EMAIL PROTECTED] 602-604-3100
-
We are using Postgres 7.3.2 on a Solaris box.
When I dump a schema with a SEQUENCE in it, it shows the MAXVAL as
2,147,483,647.
Is it possible to set this number higher?
When we get to maxval, does it wrap?
--
-
Naomi
u forgot the closing semicolon. Try:
Select * from groupes;
It didn't know you were done typing.
--
-
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. [EMAIL PROTECTED] 602-604-3100
Jie Liang wrote:
Does 7.3* support this? Can you tell me a bit more about it, please?
Hash aggregate..?
>I had a similar problem after upgrade to 7.4.2,
>Try:
>SET enable_hashagg = false;
>Before you execute that SELECT stmt
>If you don't want disable it in postgresql.conf
>
>Jie Liang
>
>
message can get through to the
mailing list cleanly
---------
Naomi
Walker
Chief Information Officer
Eldorado C
At this time, we do not have point in time recovery. That is slated for 7.5 (we
hope). There is also no way to perform incremenatals (yet).
-Original Message-
From: [EMAIL PROTECTED] on behalf of Eric Yum
Sent: Mon 4/5/2004 7:34 PM
To: [EMAIL PROTECTED]
of dozens of tapes and CDs ... Informix was rarely more a CD and
>much easier to get going.
And, IMHO, Informix *much* easier to maintain.
---------
Naomi Walker
At 03:36 AM 4/2/2004, Bradley Kieser wrote:
>Hi Tony,
>Yep, for the time being you're pretty much limited to this for a table. As
>far as commercial DBs go, IMHO (without knowing about DB2) Oracle is the
>only player in town that will realistically deal with table sizes in the
>order of 100sGB o
ing postgres 7.3.4 on Solaris and Redhat Linux servers.
Naomi
-----
Naomi Walker Chief Information Officer
Eld
I would still love this feature for when in the COPY mode.
> regards, tom lane
-----
Naomi Walker Chief Information Officer
) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup.| Newtown Square, Pennsylvania 19073
-----
Naomi Walker
I'm not sure of the correct protocol for getting things on the "todo"
list. Whom shall we beg?
At 10:13 AM 3/22/2004, Mark M. Huber wrote:
>That sounds like a brilliant idea, who do we say it to make it so?
>
>Mark H
>
>-Original Message-
>From: Naom
om pg_dump. So...
>my 50 row table recovery took < 10 Min.
>
>Thanks for your help.
>
>Mark H
>
>
>---------
>Naomi Walk
//www.vmdirect.com
>3035 E. Patrick Lane
>Suite #1
>Las Vegas, NV 89120
>
> <>
>
---------
Naomi Walker Chief Information Officer
is your friend
---------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc.
[EMAIL PROTECTED]
think
it would be an important addition to postgres?
Naomi
-
Naomi Walker Chief Information Officer
Eld
ction log file 0006002E
2004-02-05 16:48:38 LOG: recycled transaction log file 0006002F
-
Naomi Walker Chief Information Of
DACafeMail.
>Get Your FREE 25 MB eMail Account Now.
>http://cafemail.dcccafe.com
>
>---(end of broadcast)---
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
-
PROTECTED]
-----
Naomi
Walker
Chief Information Officer
Eldorado Computing, Inc.
[EMAIL PROTECTED]
60
y but curious,
Naomi
---------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc.
[EMAIL PROTECTED]
>--
>Ray Ontko [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
>Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
>
>-
sts at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
-----
Naomi Walker Chief Information Of
At 09:40 AM 10/20/2003, Tom Lane wrote:
>"Monica Robustelli" <[EMAIL PROTECTED]> writes:
> > If I transfer the backup file to another Linux machine, Red Hat 9,
> Postgres
> > 7.3, I'v some problem during the database restoring. The error is:
>
> > ERROR: copy: line 13, CopyReadAttribute: end of r
Thank you. I was just double-checking..
At 09:32 AM 10/15/2003, Tom Lane wrote:
>Naomi Walker <[EMAIL PROTECTED]> writes:
> > When upgrading to a minor release (only third digit changing),
> > specifically, 7.3.2 to 7.3.4, do I have to pg_dump and reload everything?
>
When upgrading to a minor release (only third digit changing),
specifically, 7.3.2 to 7.3.4, do I have to pg_dump and reload everything?
Naomi
-- CONFIDENTIALITY NOTICE --
This message is intended for the sole use of the individual and entity to whom it is
addressed, and may contain informat
I regularly need to unload some rows from tables, and load into different
databases, sometimes on different hosts. In simple cases, I can do
something like:
psql -At -d dbname -c "select from table where"
Due to some embedded tabs and other anomalies in our data, we then have t
--
>TIP 4: Don't 'kill -9' the postmaster
---------
Naomi Walker Chief Information Officer
El
I noticed in some (older) documentation that views were read-only? Is this
still the case?
Naomi
-
Naomi Walker Chief Information Officer
I need to grant access to all tables for all users on a particular
database. I've tried:
GRANT ALL ON databasename to public;
But it complained the databasebase (relation) does not exist. Do I have to
grant on each table in a separate statement? I'm guessing not.
Naomi
-- CONFIDENTIALITY
n the
future?
------
Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
[EMAIL PROTECTED]
602-604-3100 x242
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Is there a way to see timestamps in the pgsql.log?
If not, could I please get that on the todo list?
--
Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
[EMAIL PROTECTED
Can we add unload/load functionality to the list, please?
> >Yes, agreed, it would be nice to have WHERE as part of COPY. In fact, I
> >like Informix's solution, which merges data in/out with INSERT/SELECT:
> >
> > UNLOAD TO '/tmp/x'
> > SELECT *
> > FROM tab;
> >
> >an
n/out with INSERT/SELECT:
UNLOAD TO '/tmp/x'
SELECT *
FROM tab;
and
LOAD FROM '/tmp/x'
INSERT INTO tab;
It is tough to beat this flexibility.
-------
Naomi Walker wrote:
clean way.
Back to the maddening crowd. Anyone at least agreed this is needed? Could
we add "where" clauses to COPY? That would be perfect.
------
Naomi Walker
Eldorado Computing, Inc
postgresql
equivalent?
Suggestions?
Thanks,
Naomi
------
Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
[EMAIL PROTECTED]
602-604
At 05:23 PM 7/9/02 +0200, Stefano Coletta wrote:
>I had problems when a power failure occurred on old postgres
>installations. I had to use pg_check to fix problems.
>
>Now I have installed an UPS just to make a clean shutdown of the system. I
>strongly suggest you to purchase an UPS, just to ma
At 12:18 PM 6/3/2002 , Andrew Perrin wrote:
>What's the reason for doing this? Just use separate databases -- if
>necessary, with different users given permissions on each -- in the same
>postmaster instance.
We will be using separate instances for failover purposes in our clustered
environment.
I'm not sure how well this works in Postgres. For Informix, we could trick
the optimizer into using an index with something like:
Select colname from table where colname !=NULL.
Specifically mentioning the column in the query was the trick. In esql/C,
there were return parameters that then
Every night I VACUUM ANALYZE our databases. I've asked in the past, and
was told not to worry about this. One database never returns a
message. This database consistently returns this message. What odd thing
am I tripping over?
>Before Vacuum
>Sat May 11 02:00:54 MST 2002
>psql:/usr/local/
nds, if you've got application programs that have written a whole
>lot of pages since the last sync.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
. Anyone know the
>magic incantation for large-file support on Linux?
depending on the shell being used, i'd try limit or ulimit
We've seen a case where large file support had to be tweaked in the Veritas
file systems as well.
--
Naomi Walker
Chief Information Officer
Eldorado Com
L PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
>Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
>
>
>---(end of broadcast)-------
>TIP 4: Don't 'kill -9' the postmas
At 11:22 AM 2/26/02 -0500, Jeff Self wrote:
>Journaled file systems will typically slow down a database somewhat.
Yes, but will make booting ALOT faster. Plus, the ability to grow a
filesystem is very nice, and that is sometimes bundled in the products
(like Veritas).
--
Naomi Walker
Ch
for a database management systems. The more
people that use Postgres, the better for all of us, and this is a critical
piece..
Please email me if you are interested in such a venture or have any comments.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-60
se (so it would write stuff in the log), and
noticed that the renamed log ('date'.log) was the one written to, not the
new pgsql.log.
Do I have to bounce the cluster to roll the log? How should I be
performing this task?
--
Naomi Walker
Chief Information Officer
Eldorado Computing, I
unt and bit pusher extraordinaíre
>
>_
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>---(end of broadcast)---
>TIP 1: subscribe and u
My guess is that this will not be hard to fix. What did you have to
change, exactly, to make it work? I've got a mixed case dbname.
At 11:33 PM 2/9/02 +0100, Simone Tellini wrote:
>On Sat, 09 Feb 2002 23:23:20 +0100
>Simone Tellini <[EMAIL PROTECTED]> wrote:
>
>ST> ST> will try to /connect Te
Eldorado Computing, Inc. 602-604-3100
> 5353 North 16th Street, Suite 400
>Phoenix, Arizona 85016-3228
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
---(end of broadcast)---
TIP
At 01:53 PM 2/8/02 -0500, Bruce Momjian wrote:
>Naomi Walker wrote:
> > We are currently using Postgresql 7.1.2, running on a E3500 server, OS
> > Solaris 2.6. We would like to upgrade to postgresql 7.2.
> >
> > 1) Do you all consider it stable enough now to upgrade?
with versions of postgres 7.1 and higher.
Why did pg_upgrade go away, and can we look forward to one in the future?
Thanks,
Naomi
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
---(end of broadcast
me. I've
>seen
> > pg_xlog files mentioned.
> >
> > The recovery section of the manuals is 'under construction' it seems.
> >
> > Thanks for your help.
> >
> > Cheers
> >
> > Andy Marden
> >
> >
>
>
>
&
ty file it
said '../pgsql/data/base/template1/pg_class not found'.
Am I missing something? are there any other steps to a filesystem
backup?
-sonny
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
me when challenged for a password, logged in
as postgres, whether or not they want the database password I am working
on, or postgres'. So far, it appears to be asking for the postgres
password.
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
>
>AFAIK, if you're using a recent 7.2, the default VACUUM shouldn't prevent
>inserts/updates/deletes from the table while the vacuum is occuring.
Could someone please point me at a document explaining how to migrate from
7.1 to 7.2?
--
Naomi Walker
Chief Information Officer
89 matches
Mail list logo
