nd performance improvements that have
been made in the several years since 8.4 was released.
Cheers,
Steve
/redhat/rhel-6-x86_64/pgdg-centos91-9.1-4.noarch.rpm
I just did exactly that upgrade earlier this week albeit for the
client-side only. Don't use 9.2 if you are looking for 9.1.
Cheers,
Steve
My interpretation is that if your kernel enforces things properly you
don't need to worry. If it doesn't, reduce your max_connections and/or
max_files_per_process as needed.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your sub
t
> ERROR: exceeded MAX_ALLOCATED_DESCS while trying to open file
> "/srv/www/data/antidote/registre.csv"
>
> What is it MAX_ALLOCATED_DESCS? and how can I modify it without changing
> the code and re-compile? I tried using postgref.conf but this parameters
> is
recognize.
thanks
steve
as Slony and
many can migrate a single database or even specific table(s).
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
se if I just
wait a minute or two but the number of those transactions, while visible
on an idle system, is lost in the noise on a busy database.
Other things that generate transactions include connecting to the
database (one, it appears) but \d in psql appears to generate a minimum
of f
ltimately it is their responsibility to make the decision whether or
not to upgrade. It is your responsibility to provide the data necessary
to help them make an informed choice.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your sub
ts fork pg_repack
(https://github.com/reorg/pg_repack) which essentially do the copy to a
new table in the background then briefly lock the tables to apply any
recent changes from the master before dropping the copy into place.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admi
On 11/28/2012 11:24 AM, Shams Khan wrote:
Thanks for the response Steve...It was really helpful:
Below are some doubts I wanted to clarify..please read and suggest.
Can we also check if replication was broken earlier...somehow due to
power failure of some other reasons in past...The reason I
ere name='transaction_read_only';
\o
\i ${tempquery}
EOS
)
# Cleanup temp file
test -f "${tempquery}" && rm "${tempquery}"
# Do some alert based on the number of seconds of lag between master and
standby here
Cheers,
Steve
--
Sent via pgsql-admin mailing lis
On 09/27/2012 07:01 PM, Greg Williamson wrote:
Steve (and others who replied):
...
The other is a slimmed-down version of our production database, which gets
recreated hourly by a shell script which pulls data from remote servers, does a
pg_dump of the resulting 3 gig database, and then drops
heir disk space until the process
exits. Perhaps a script or scripts, even one of your hourly ones, that
terminate when the server restarts? You could save the output of lsof
and ps immediately before and after a restart and compare them.
Let us know what you find.
Cheers,
Steve
--
Sent
/static/release-9-1-6.html nor news
http://www.postgresql.org/about/news/1416/ indicate that any special
handling is required on standby servers. Can anyone confirm if that is
correct or, if not, what additional steps are prudent?
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin
. One
possibility is a running backup.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ee do not and, in fact,
can be set by a user on a per-connection basis.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
tion setup time will become an issue
so connection-pooling and persistent connections will be useful.
Cheers,
Steve
ica/Los_Angeles'. -07 is an offset, 'America/Los_Angeles' is a time
zone and deals appropriately with Daylight Saving Time and the various
changes thereto through history.
Should it be necessary, you could save time zone information in a
separate column. Note that you can specify tim
her than just a pre-defined n-hours?
I'm currently looking at using the recently announced pgbarman to
simplify the overall process. (http://www.pgbarman.org/)
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http:
this will raise a host of security problems.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
they had heard of a
client "who did this once". They had no idea what slony means. So I am
not feeling so warm and fuzzy about them.
Good call.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgres
the developers). Perhaps 9.2
final will be released before your database grows too big for current
solutions.
Cheers,
Steve
127.0.0.2 for its address)?
The "unsupported frontend protocol" leads me to believe that the network
connection is succeeding but the client-server conversation thereafter
is incorrect or absent.
Cheers,
Steve
t;,
":set encoding" and ":set fileencoding".
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
mp program to see the actual bytes in the file
and determine if they are what you expect for UTF8.
Cheers,
Steve
are still stuck after checking/fixing the above you could
actually have bad data in your input or, possibly, an incorrect
byte-order issue though that is unlikely in most situations.
Cheers,
Steve
ersion of PG? OS? Is the database able to start?
Are you attempting to connect as a superuser?
With this as a starting point you may get some valuable advice (though
from those people far more capable of answering this question than I).
Cheers,
Steve
--
Sent via pgsql-admin maili
de is:
"Name of the on-disk file of this relation; zero means this is a
"mapped" relation whose disk file name is determined by low-level state"
However the meaning "mapped relation" and "low-level state" are
difficult to divine from the docs. Go with
uot;,
in their Filenodes.
Since you are getting different results from the OS tools (ls, du) on an
XFS system I'd check for info on XFS lists.
Googling "xfs du ls size difference" gives about 95,000 pages related to
this issue.
Cheers,
Steve
--
Sent via pgsql-admin mailing l
ne project but partners on another - a not unusual
situation. You could also include valid dates for relationships or
whatever else you deem necessary.
Given the appropriate recursive query, you could build a full tree of
partnerships for a given organization/project.
Cheers,
Steve
wiki page may be of help:
http://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux
Cheers,
Steve
On 11/09/2011 11:41 AM, Geoffrey Myers wrote:
Geoffrey Myers wrote:
Tom Lane wrote:
Steve Crawford writes:
On 11/09/2011 05:10 AM, Geoffrey Myers wrote:
Is there a way to retain this information from the original
database when reloading?
Time-zone setting is an attribute of the server
.conf.
Clients can override the default server setting with "SET TIMEZONE TO
...;" which is useful when a single server is supporting users across
many time zones.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
the queries you
run longer than 450ms?
#log_statement = 'all'
I don't know what the config looked like beforehand but did you reload
PostgreSQL after changing it? You can check the current running settings
with "show all;"
Cheers,
Steve
--
Sent via pgsql-admin
select statement was wrong. I
needed to SELECT currval('jobs_id_seq') not the field name, which I
was doing.
Yes, this is probably the real root of your problem. I did not notice
that since I didn't have the table definition in front of me.
Cheers,
Steve
..@mail.com', '2', 'This position mostly tutors, instructs, or
directly assists students. Less than half of the position tasks are
clerical or support duties.', '10', '28', 'all', '70%',
'09-20-2011');SELECT currval(id);
Marc
You are combining two statements into one - this is not correct.
Not sure why you can't use returning - it works for me (where bar is
some text and fooid is serial):
insert into footest (bar) values ('abcde') returning fooid;
But if you really can't, then just execute the two statements sequentially:
insert into.;
select currval('id');
Cheers,
Steve
On 09/14/2011 08:48 AM, Steve Crawford wrote:
On 09/13/2011 05:31 PM, Tom Lane wrote:
Steve Crawford writes:
waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol
lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping
There were problems executing "/usr/pgsql-9.
On 09/13/2011 05:31 PM, Tom Lane wrote:
Steve Crawford writes:
waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol
lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping
There were problems executing "/usr/pgsql-9.1/bin/pg_ctl" -w -l
"upgrade.log"
[FAILED]
[root@foo ~]# service postgresql-9.1.0 initdb
postgresql-9.1.0: unrecognized service
[root@foo ~]# service postgresql-9.1 initdb
Initializing database:
Any thoughts?
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On 11-08-11 02:24 PM, CS DBA wrote:
Hi All;
we're trying to get PostgreSQL configured on an AIX box (AIX version 5).
After some digging & adding various paths to LD_LIBRARY_PATH (Thanks
to help from Tom Lane) we were able to complete the source based build.
However, when we try and start the
On 07/20/2011 02:04 PM, Steve Crawford wrote:
On 07/20/2011 12:58 PM, A J wrote:
I understand that 'cluster' performs the role of defrag ...
As with everything the answer is "it depends". For a "typical"
workload where the rows updated by a single query are one
appropriate
solution as well. You may also get tips on avoiding some common pitfalls
that can prevent PostgreSQL from showing its full potential.
Cheers,
Steve
On 07/13/2011 04:32 PM, Tom Lane wrote:
Steve Crawford writes:
I've seen the "could not open relation with OID" error a couple times
recently ...
Not worry
You might be able to dodge the problem by excluding temp relations from
the reporting query, though whether the sum o
processes that use temporary tables
(there are currently 35 pg_temp_XX schemas with the highest being
pg_temp_55)
So...
Worry or not worry?
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On 07/07/2011 08:29 AM, francescobocca...@libero.it wrote:
Hi,
i tried to run :
/postgresql-9.0.4-1-linux.bin
but i received segmentation fault error. So i think, after Steve reply, that
the best way to install postgresql 9.0 is to install Ubuntu 10.04. Am i
right?
Thanks for your help,
Best
source you may have
difficulty updating your system to install anything needed since 9.04 is
no longer supported by Ubuntu.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
u will
need to clean each one.
Reset stats collector at startup.
Check system after each change and report back if anything improves or
degrades the situation.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www
12/17/2010';
Thanks
Marc
If by "unix timestamp" you mean epoch, just extract the epoch from your
date or timestamp:
steve=# select extract(epoch from date '12/17/2010');
date_part
----
1292572800
Cheers,
Steve
connection statement are you using?
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
quirements, foreign-key constraints or the like.
If availability is truly critical, be sure to test whatever approach you
take in advance.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
year?) child table. When
the time comes, just archive and drop the child.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
est and monitor.
--
Steve Francis
LogicMonitor
LLC
sfran...@l
Berkeley DB comes to my mind) would create heavily fragmented files.
--
Steve Francis
LogicMonitor
tgres
server itself?
Thanks!
--
Steve Francis
LogicMonitor
res on the replica does it make a difference?
How about with a LIBPATH=/apps/pg_9.0_b4/lib/postgresql
(I'm not exactly sure where libpq.a is on your install)
Alanoly.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
--
Sent via pgsql-admin mailing list (pgsql-admin
Thanks Kevin,
Which of these 2 methods is the best practice?
It is working with pgpass.
But not yet with hba.conf
I tried this without success.
hostall all 127.0.0.1/32 trust
steve
"Kevin Grittner"
27/07/2010 01:17 PM
A
,
cc
Objet
Re: [ADMIN]
admin.
How to avoid that? I guess there is a config so dbadmin will "trust" this
new user
Thanks for your help,
Steve
and
more tips at:
http://it.toolbox.com/blogs/database-soup/using-84-parallel-restore-with-your-83-or-82-database-31575
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
rrent
releases of the dump programs can read data from any server version back
to 7.0."
How many cores are available on the new server?
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello
This is Steve Nayam from MRS. I am looking for Postgresql DBA consultant.
I just want to know if you can help me in this regard, can I post jobs here.
Thank you
Regards,
Steve Nayam
Business Development Manager
Maple Resource Specialists (MRS)
973-494-5751 - USA
n see) and this is
correctly keeping the stats up to date. The only difference is postgres
has been running well over a year on the server with the issue.
Many thanks in advance,
Steve Jones
have either a contact or submit-story link. There is
also a separate "advocacy" mailing list.
Cheers,
Steve
Mary Anderson wrote:
Me too. we have been using PostreSQL for three years now in the
demography department at UC Berkeley. It is great. My specs from my
academic boss we
ppear to work for a while until it suddenly doesn't?
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
les/columns?
Try (as the database administrator), "vacuum full pg_attribute" perhaps
followed by "reindex table pg_attribute". Be aware that this may pretty
much lock your database while it is running. See if things improve then
do as Tom says - make sure autovacuum is r
complete meltdown in real life because
all the modem users kept processes occupied for long periods while the
data dribbled back and the server maxed out on available threads/processes.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
traffic to deplete your available pg connections in seconds,
not minutes so keep digging.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ve to check those as well. Perhaps look at the connection start time
in PG and try to correlate it with a request in your webserver log.
I assume you would have told us if you are running pgbouncer or similar
pooling solution as that would be an obvious cause.
Cheers,
Steve
--
Sent via pgsql-admin
csvfilename CSV delimiter '|'
or export data (tab-delimited):
copy foo to stdout CSV DELIMITER E'\t';
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
lfrozenxid | xid | not null
relacl | aclitem[] |
reloptions | text[]|
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
/init.d/ and /etc/postgresql/ for starters). I'm guessing you may
find both versions are available but your boot configuration is starting
the wrong one.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresq
ngs like schema-only,
data-only, specific tables, etc.
If the data is not a PostgreSQL created dump, you need to do some work
yourself. For example, if it is a CSV file you need a table with the
correct columns and you can use psql and the copy command with the csv
option.
Cheers,
Steve
ernally for feeding
into your database-backed processes (for fun, try "-d yesterday" and "-d
tomorrow" in most versions of the "date" command in the vicinity of DST
changes).
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make chan
vacuum and last_autovacuum columns. I don't know when those columns
were added. I don't see them in 8.1 and don't have 8.2 available at the
moment.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.post
e') to automatically generate
a new value for each record).
A primary key could be a serial, but doesn't have to be.
A serial can be a primary key but doesn't have to be.
Note: due to things like transaction rollbacks, a serial column will
have unique IDs generated but they are not
Hi,
Just wondering what actually happens when the connection limit exceeds.
Dec 10 05:19:45 pallas1 postgres[373]: [2-1] FATAL: connection limit
exceeded for non-superusers
Are the requests that are rejected pooled and processed when connection
slots are available?
--
Sent via pgsql-admin ma
hat drwtsn.exe is some form of malware - Google for more
info. Before proceeding with PostgreSQL troubleshooting, I'd make sure
that the machine itself is fully cleansed and checked.
Cheers,
Steve
onitoring tools such as Hyperic that have PostgreSQL plugins:
http://www.hyperic.com/products/managed/postgresql-management.htm
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
tions regarding write-ahead logging may be found here:
http://www.postgresql.org/docs/8.3/interactive/wal-configuration.html
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
nk that
if you are using archive_command setting to archive WAL files the
archive command does not return "success", then the WAL file will not be
removed/reused.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
[EMAIL PROTECTED]> CLUSTER pg_class USING pg_class_oid_index ;
ERROR: "pg_class" is a system catalog
I think the DB is probably protecting you from yourself here ;-).
And elsewhere. :)
I wasn't ad
r mode):
[EMAIL PROTECTED]> CLUSTER pg_class USING pg_class_oid_index ;
ERROR: "pg_class" is a system catalog
Should the docs
(http://www.postgresql.org/docs/8.3/interactive/sql-cluster.html) be
updated to note this restriction?
Cheers,
Steve
--
Sent via pgsql-admin mailin
discovered
that cron scripts using temporary tables can cause very rapid
system-table blotage.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
: Steve Crawford
Cc: Scott Marlowe; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hex representation
Well, it was a bit convoluted, but I created the file with Excel,
filling the right number of cells with \x55. This worked too. The
script wouldn't run for me. I got an error about a
Scott Marlowe wrote:
I used this very simple little php script to make this
filename: mk55:
#!/usr/bin/php -q
Or, using standard *nix tools (Note: 0x55 = ascii U):
dd bs=1k count=256 if=/dev/zero | tr '\000' U > full_of_0x55
Cheers,
Steve
--
Sent via pgsql-admin mailin
Is there any negative effects by doing this?
The swappiness is sitting on the default 60 at the moment.
On Wed, 17 Sep 2008 00:46:13 -0600, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Tue, Sep 16, 2008 at 11:30 PM, <[EMAIL PROTECTED]> wrote:
>> Hi All
>>
>>
>> I recently made a change to my
?
Cheers
Steve.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Why not just export as 'insert into (... ) values (...)' format. If
ingres can't export as such, you can write a select statement to do this.
Slow, sure - but the lowest common denominator.
Steve
On Wed, 10 Sep 2008 11:27:58 -0400
"Markova, Nina" <[EMAIL PROTECTED
t you want in a simple, repeatable manner.
If it's mysql 5 then the stored procedures may need to be converted - I know
there are tools out there, but haven't used them and can't comment.
Steve
--
Steve Holdoway <[EMAIL PROTECTED]>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
WAL's. You can
add the current X log to the WAL and recover your DB to its existing state.
On Thu, 28 Aug 2008 05:24:56 -0700 (PDT), [EMAIL PROTECTED]
wrote:
> Thanks Steve.
>
> If I understand your comment regarding the 16MB limit, it means I should
> not worry about the WAL file
Looks like the relevant Visual C runtime library ( VC80.CRT 32 bit ) needs
installing first...
Steve
On Thu, 28 Aug 2008 09:42:54 -0500
"Brandon Dybala" <[EMAIL PROTECTED]> wrote:
> I tried installing PostgreSQL 8.3.3 on Vista Business, and initdb failed
> to start duri
ready knows.?
On Wed, 27 Aug 2008 13:49:13 -0700 (PDT), [EMAIL PROTECTED]
wrote:
> Steve, thanks for your response and your question.
>
> Ok, here is some clarification on the WAL file name used in the example
> below.
>
> The WAL file name I used in the example is actually
> 000
0001223387 would usually be the next WAL to be written.
How often are you WALs written out?
On Wed, 27 Aug 2008 07:07:17 -0700 (PDT), [EMAIL PROTECTED]
wrote:
> I have a question regarding the WAL files that are moved during a backup
to
> the "archive directory".
>
> I have setup
Hi Richard,
This means a file systems backup. eg.
tar -cvpf data_bakup.tar /var/lib/pgsql/data
Here's a script I use to automate this process. It may be helpful to
customize for yourself.
#!/bin/bash
#
# PostgreSQL Weekly Backup
#
DATE=$(date +%G%m%d)
MAILLOG="/backup/weekly_$DATE.log"
WALAR
Correction, perms are 600.
On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <[EMAIL PROTECTED]>
wrote:
> On Tue, 26 Aug 2008 14:11:13 +1200
> Steve Holdoway <[EMAIL PROTECTED]> wrote:
>
>> On Tue, 26 Aug 2008 10:42:19 +1000
>> <[EMAIL PROTECTED]> wrote:
>
Yeah, thought about that but as you said the perms on the logs are 700. on
both stderr and syslogging.
On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <[EMAIL PROTECTED]>
wrote:
> On Tue, 26 Aug 2008 14:11:13 +1200
> Steve Holdoway <[EMAIL PROTECTED]> wrote:
>
>> O
or ownership
>
>
> Thanks
>
> Steve
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
Add that user to the postgres group?
--
Steve Holdoway <[EMAIL PRO
Hi all,
Is there a way to make the postgres logs readable by other users or a group
apart from postgres:postgres?
I am on postgres 8.1
I cannot see any feature to allow setting perms or ownership
Thanks
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
I am also curious as to why an SQL dump from the production server would
come out to 2.8G but a dump of an exact replica on a test box would come
out to 3.0G. What determines the size and makeup of an SQL dump?
Cheers.
Steve.
On Fri, 15 Aug 2008 12:24:32 +0200, Tino Schwarze <[EMAIL PROTEC
ql, pg_dump, etc.
(I did say "accidentally". If everyone is clued in, you can have
multiple versions of PG running on the same machine. If not, you will be
answering questions due to the unexpected behavior.)
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.o
Nice, that has cleared it up.
I am on 8.1 also.
On my test box, a standard dump took 6m 26sec & a -Fc dump took 11min 2sec.
That's not a great difference, but the size difference is quite noticeable.
Thanks for your help.
Steve.
On Fri, 15 Aug 2008 02:15:25 +0200, Thomas Jaco
1 - 100 of 266 matches
Mail list logo