On Jul 26, 2013, at 1:42 PM, Tim Spencer wrote:
> On Jul 25, 2013, at 11:45 PM, Joe Van Dyk wrote:
>> Have chef supply the password in encrypted format.
>>
> I was hoping that somebody would be able to solve my logging issue instead
> of me having to rejigger my nice centralized password syst
I used "initdb -U" to specify an alternate superuser. On startup it
throws these msgs:
2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does
not exist
2017-06-22 14:36:34 EDT,0,startup LOCATION: InitializeSessionUserId,
miscinit.c:503
--
Sent via pgsql-general mailing
thoughts.
—Ray
On 6/22/17 4:07 PM, Adrian Klaver wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On startup it
Can you show your complete initdb command?
throws these msgs:
2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgr
On 6/22/17 4:10 PM, Melvin Davidson wrote:
On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On
startup it
C
On 6/22/17 4:34 PM, Adrian Klaver wrote:
On 06/22/2017 01:29 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 01:13 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell mailto:ste...@
On 6/22/17 4:36 PM, Adrian Klaver wrote:
On 06/22/2017 01:16 PM, Ray Stell wrote:
On 6/22/17 4:07 PM, Adrian Klaver wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On startup it
Can you show your complete initdb command
you can modify the init.d (or service) file and
add a line to delete the file.
To remove on crash is likely to require some sort of ongoing monitoring
service to see that the process is no longer running.
If you’re already using a service (such as monit) which brings an
application back up after
On Fri, Feb 15, 2008 at 10:21:16PM +0800, Phoenix Kiula wrote:
>
> http://ogasawalrus.com/blog/node/462
"Reading more carefully"
sounds like it was the first read to me.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
How to get ssl configured on RHEL3? Can't seem to hook up
with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
$ cat /etc/issue
Red Hat Enterprise Linux AS release 3 (Taroon Update 9)
Kernel \r on an \m
$ rpm -qa | grep ssl
docbook-style-dsssl-1.76-8
mod_ssl-2.0.46-70.ent
openssl-0.9.7a-33.
On Wed, Feb 27, 2008 at 03:22:57PM -0500, Tom Lane wrote:
> Ray Stell <[EMAIL PROTECTED]> writes:
> > How to get ssl configured on RHEL3? Can't seem to hook up
> > with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
>
> Weird. Did you look into config.l
On Fri, Apr 11, 2008 at 04:48:03PM -0500, Erik Jones wrote:
> On Apr 11, 2008, at 4:23 PM, Stefan Sturm wrote:
>> I don''t want to kill them. So how can I find out, what ist locking them?
>> Is there a tool, which shows me such Information?
>
> There is a system catalog view called pg_locks that ha
On Wed, Jun 03, 2009 at 08:13:48AM -0400, Geoffrey wrote:
> I'm certainly looking at rsync rather then scp, which really makes more
> sense.
You can mix ssh and rsync. The man pages has this example:
rsync -az -e ssh --delete ~ftp/pub/samba/ nimbus:"~ftp/pub/tridge/samba"
--
Sent via pg
On Tue, Jun 23, 2009 at 10:24:28AM -0400, Merlin Moncure wrote:
> If you are
> adventurous/enterprising, you could dig up the hot standby patch, get
> it in line with the soon to be released 8.4, and play with it...it
> works very well.
What is the entry point for source and config documentation o
On Tue, Jun 23, 2009 at 01:31:59PM -0400, Merlin Moncure wrote:
> not sure what you mean by entry point? getting it running is a snap
> if you've already ever done a warm standby setup. The hard part will
> be patching it in.
In my case, I'd need to know where the patch can be downloaded and whe
On Wed, Jul 29, 2009 at 09:05:37AM -0400, mzh...@ilww.com wrote:
> Caused by: org.postgresql.util.PSQLException: PANIC: could not write to
> log file 6, segment 176 at offset 14991360, length 8192: Read-only file
> system
You need the sysadmin to examine the OS status. It's possible the system
On Fri, Aug 07, 2009 at 01:54:47PM -0600, Scott Marlowe wrote:
> You're probably better off switching to explicitly backing up
> databases in the custom format and using a single pg_dumpall --globals
> to backup the users accounts and such.
-g
--globals-only
Dump only global objects (roles
On Sat, Aug 22, 2009 at 01:03:43PM -0700, Sergey Samokhin wrote:
> Is there a way to disconnect all the clients as if the server has
> crashed? It should look like a real crash from the client's point of
> view.
ifconfig ethx down ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
On Sep 13, 2013, at 3:51 PM, Raymond O'Donnell wrote:
> [1] and one of the wiki
> articles [2] seem to indicate that you need to set up log-shipping as
> well as SR, whereas one of the wiki articles [2] indicates that
> log-shipping isn't required. I've followed [3] and it seems to work fine
> in
On Sep 17, 2013, at 7:22 AM, "Echlin, Jamie (KFIA 611)"
wrote:
> Unfortunately though if there is heavy load, the wal files will be generated
> more regularly than the 5 minute max.
If you wrote the WAL to an external, mounted disk, wouldn't that solve the
issue?
On Sep 23, 2013, at 11:20 AM, John DeSoi wrote:
>
> Am I missing something obvious? Do I have to back up the primary again to
> make this change?
you didn't mention a pg_hba.conf rule. did you add one for the replication
user?
--
Sent via pgsql-general mailing list (pgsql-general@postgres
On Sep 23, 2013, at 4:47 PM, John DeSoi wrote:
>
> You mean on the primary, right?
right
> Yes, I have one there. But even if I did not, I would expect to see a
> connection error in the log on the standby. No error or any indication the
> streaming replication process is running on the stan
On Jan 17, 2014, at 5:07 AM, Granthana Biswas wrote:
> Yes it's purely for monitoring purpose.
>
I use the pg_controldata cmd locally and via bash/ssh shared keys and compare
various values that seem interesting such as "Time of latest checkpoint, Latest
checkpoint location." My interest i
On Mar 23, 2014, at 7:58 PM, Álvaro Nunes Lemos Melo wrote:
...
> the whole system is slower.
>
> Below is my data, and I really hope we can find what is happening, or I'll
> have to downgrade to 9.2 and wait for 9.4 release.
I think this is a good starting place:
http://wiki.postgresql.org/w
On Apr 4, 2014, at 12:03 AM, François Beausoleil wrote:
> I have some performance issues on a Ubuntu 12.04 which I'd like to resolve.
> iowait varies a lot, between 5 and 50%.
Is the SAN dedicated to this app? I wonder if the i/o, if not related to your
app, is being pressed by some other s
On Sun, Jun 12, 2011 at 01:41:14PM +0300, abiy hailu wrote:
> Considering the fact that it is a critical service, what can be implemented
> to improve the postgreSQL service.
take a look at these books and see which one fits your needs:
http://www.postgresql.org/docs/books/
--
Sent via pgsql-gen
On Wed, Aug 10, 2011 at 02:47:25PM -0400, Geoffrey Myers wrote:
> Is max connections in any table in the database I can access?
edbstore=> \d pg_catalog.pg_settings;
View "pg_catalog.pg_settings"
Column | Type | Modifiers
+-+---
name | text|
sett
On Tue, Aug 23, 2011 at 02:01:10AM -0700, alexondi wrote:
> Hi!
> Do I need setup wal archiving (archiving_mode = on) setup when I use
> streaming replication?
yes
http://www.postgresql.org/docs/current/interactive/high-availability.html
--
Sent via pgsql-general mailing list (pgsql-general@pos
On Tue, Aug 23, 2011 at 06:23:58AM -0700, Adrian Klaver wrote:
> On Tuesday, August 23, 2011 4:14:15 am Ray Stell wrote:
> > On Tue, Aug 23, 2011 at 02:01:10AM -0700, alexondi wrote:
> > > Hi!
> > > Do I need setup wal archiving (archiving_mode = on) setup when I use
On Tue, Aug 23, 2011 at 08:30:55PM +0530, Raghavendra wrote:
>
> Is it a best practice to keep cluster in Archive_mode = on and setup
> streaming replication or just leave archive_mode=off?
Depends. The reason for creating WAL is in case they are needed for recovery.
In the event that the stby h
turn the vol down a bit:
http://www.youtube.com/watch?v=1PoFIohBSM4
the answer is d)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote:
> is everything shown there really
> the behavior of the MySQL database itself?
Good question. I intend to install mysql one day to explore, but just can't
find the time. The particular engine is not disclosed and I've read some are
better th
On Tue, May 04, 2010 at 05:12:16PM +0600, AI Rumman wrote:
> I change the pg_hba.conf as below:
and you restart or do a pg_ctl reload?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Aug 17, 2010 at 11:02:20AM +0700, tuanhoanganh wrote:
> On Sat, Aug 14, 2010 at 10:00 AM, tuanhoanganh wrote:
> > The process cannot access the file because it is being used by another
> > process.
> > C:\...\8.3\pg_xlog\00010007001B
Exclude pg_log from the backup or rm that f
Hello,
what is the current status of the MSSQL to PostgreSQL tools/tips?
Google returns results as old as 2001...
The MSSQL database in question has only tables, no stored procedures, etc.
Thanks,
Iv
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hi Ray,
I have something that does this. I am currently awaiting project
approval on pgfoundry.
It does tables, views, and stored procedures. I have tested it on
450,000 lines of mssql code
including 400 tables and 3700 stored procedures, although it is a work
in progress.
I applied last
Gwyneth Morrison wrote:
Ray,
I think we tried that and I think it works but not for us. It may work
for you.
MS wants to copy all the tables over with exactly the same names
including [dbo]. and so on.
When it doesn't find an exact match, it wants to create the table. This
may be o
Is there a doc that covers planning disk storage of indices?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Nov 19, 2009 at 10:43:57AM -0500, Ray Stell wrote:
> Is there a doc that covers planning disk storage of indices?
http://www.postgresql.org/docs/8.4/interactive/storage-page-layout.html#FTN.AEN82952
53.5. Database Page Layout
http://archives.postgresql.org/pgsql-docs/2002-04/msg3.
it will be easier to assess
any other difficulties.
Ray
- Original Message -
From: "Raymond O'Donnell"
To: "ray"
Cc:
Sent: Monday, February 01, 2010 3:33 AM
Subject: Re: [GENERAL] How to test my new install
> On 01/02/2010 01:15, ray wrote:
> > I have j
Raymond,
Thank you. Yes, that sounds like a great step. I am new to this so I could
use a little help: What do you mean to connect to it and how would I do it?
Ray
- Original Message -
From: "Raymond O'Donnell"
To: "ray joseph"
Cc:
Sent: Monday, February
Raymond,
Thank you very much. This is exactly what I was looking for. I'll jump
right into it.
Ray
- Original Message -
From: "Raymond O'Donnell"
To: "ray joseph"
Cc:
Sent: Monday, February 01, 2010 7:08 AM
Subject: Re: [GENERAL] How to test my new i
On Tue, Apr 13, 2010 at 06:28:18PM +0530, Satish Burnwal (sburnwal) wrote:
>
> In such a case what can I do ?
don't crosspost?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Dec 05, 2011 at 12:16:29PM +0100, Frank Lanitz wrote:
> Hi list,
>
> We had in past from time to time the issue, that the standby server is
> stopping recovering, creating a new timeline and become up and running.
> In parallel to check for the reasons of this behavior we are looking for
>
I've been using a network management tool for a number of years from
cisco to manage storage networking (fibre channel). The thing is
called Fabric Manager and I was thrilled that they supported pg for the
backend when I first installed. However, their latest and greatest is
frozen to pg 8.2. Si
On Sat, Apr 14, 2012 at 09:01:10AM +, Albretch Mueller wrote:
>
> I wonder if anyone has ever gotten PostgreSQL Certified
https://www.google.com/search?q=postgresql+certification&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
--
Sent via pgsql-general mailing list (
This is probably the wrong place to mention this, but idunno:
I did a search in the docs of pg_standby and was presented this link:
Based on your search term, we recommend the following links:
* http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_standby/
but that link gives a 404
On Wed, Mar 18, 2009 at 01:18:46AM -0700, Aaron Glenn wrote:
> On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe
> wrote:
> start run it's course? for a 35GB+ database how long should I wait? is
> there no way to log the status of what the postgres daemon is actually
> doing while I wait? what's th
Hello Everyone,
I'm looking at an easy real-time application using PostgreSQL.
Looking at the pg docs, I see lots of discussion about cases where
MVCC may reflect different versions of the data to different
connections. For example:
http://www.postgresql.org/docs/8.1/static/mvcc.html
"while quer
On Mon, May 18, 2009 at 4:53 PM, Ben Chobot wrote:
> On Mon, 18 May 2009, Marsh Ray wrote:
>> Hello Everyone,
>> I'm looking at an easy real-time application using PostgreSQL.
> As I understand real-time applications, PostgreSQL is inherintly unsuited
> for the task. The
On Mon, May 18, 2009 at 5:24 PM, Sam Mason wrote:
> Even then it's not useful to class it as real-time; nothing "bad"
> happens if you don't get a response before timeout the user just gets an
> error message. Real-time applies when if you don't get a response the
> plane crashes or a heart stops
On Mon, May 18, 2009 at 5:14 PM, Sam Mason wrote:
> On Mon, May 18, 2009 at 04:38:36PM -0500, Marsh Ray wrote:
>> The central question: So if I successfully commit an update
>> transaction on one connection, then instantaneously issue a select on
>> another previously-ope
On Mon, May 18, 2009 at 6:20 PM, Tom Lane wrote:
> Marsh Ray writes:
>> The central question: So if I successfully commit an update
>> transaction on one connection, then instantaneously issue a select on
>> another previously-opened connection, under what circumstances am
We are using PostgreSQL for more than 5 years by now and at least the
last 2-3 years we experience the following situation.
We refresh the live database on the development server using the
following shell script -
/usr/local/etc/rc.d/postgresql stop
rm -r /home/data/postgresql/data
/usr/loc
Both explanations sound very similar and very logical indeed.
Never occurred to me to think that way.
Actually, now I remembered, that in a few rare occasions we had to
restart the whole server after the "refresh" and then there was no
problem, at all.
Thank you both! Iv.
--
Sent via pgsql-
is this what you mean?
testdb=# \d foo_view
View "public.foo_view"
Column | Type | Modifiers
+---+---
x | character varying(20) |
stuff | text |
y | character varying(20) |
View definition:
SELECT a.x
On Sun, Oct 01, 2006 at 12:55:51PM +0200, MaXX wrote:
>
> Pure speculation: are you sure you aren't vacuuming too agressively?
> The DELETE waiting and SELECT waiting sound to me like they are waiting
> for a lock that another vacuum is holding.
How would one determine the lock situation defini
ls -l /
maybe /data is a symlink?
On Fri, Oct 06, 2006 at 07:10:12PM +0530, km wrote:
> Hi all,
>
> I have installed postgresql(8.1.4) data dir on a partition (/data) which
> rests on a separate disk from OS disk. The install dir is default
> (usr/local/pgsql).
> Now when i use use pgbench
On Thu, 19 Oct 2006 06:14:46 -0600, Rick Gigger wrote:
> I think we've got it figure out though. We were able to patch up the
> db enough to extract the data with some help from google and old postings
> from Tom.
It would be really great if you put down the specifics of what you
googled/old post
On Fri, Oct 20, 2006 at 10:56:09PM +0930, Shane Ambler wrote:
Someone in the thread mentioned having to clean up shared mem. I've had
to do this often with oracle:
root# ipcs
-- Shared Memory Segments
keyshmid owner perms bytes nattch status
0xe97c83a
I find the following comment in dbt2 users guide: "The test kit
currently only supports SAP DB but work is currently being done to
support PostgresSQL." In the source tree of dbt2-0.39 has the file
./README-POSTGRESQL. Is this the entry point doc that a postgresql
user should start with to begi
I was interested in going down that path. This thread seems to be sparc
oriented. How about on opteron? Will pg work on solaris10 without too
much stress?
> isainfo -v
64-bit amd64 applications
sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmov amd_sysc cx8
tsc fpu
32-bit
"The large print giveth and the small print taketh away" - Tom Waits
On Tue, Nov 21, 2006 at 10:34:28PM +0100, Magnus Hagander wrote:
> > I intended to read a thread I caught part of in Oct, so I went to the
> > archive: http://archives.postgresql.org/pgsql-general/
> > Seems most of the mon
On Fri, Nov 24, 2006 at 04:42:56PM -0500, Tom Lane wrote:
>
> Surely that is not a correct tunnel setup ... you can't have both ends
> being the same port number on the same machine. There Can Be Only One
> process listening on a given port per machine.
I think he is refering the -L option of s
One suggestion would be to not cross post to admin and general and answer
the question sent back to you on the admin list, but that's just me.
On Mon, Nov 27, 2006 at 04:59:22PM +0200, Doron Baranes wrote:
>
> Hi,
>
> I installed postgres 814 on solaris 10 using the following packages
> SUNWp
a shell
http://en.wikipedia.org/wiki/Shell_%28computing%29
On Wed, Dec 20, 2006 at 10:59:05AM -0800, Bob Pawley wrote:
> I haven't used the command lines previously having relied on PG Admin.
>
> In the instructions -
> "Starting postmaster
> Nothing can happen to a database unless the postmas
On Mon, Jan 29, 2007 at 01:27:19PM -0800, Karen Hill wrote:
> there any worry in the community that oracle will begin to target
> postgres like they're targeting mySQL?
I attended a big ora conference in 2006 and was a bit surprised to
observe the fact that ora corp keynote addresses did not even
I have a query which is running a bit slowly, and I'm wondering if anyone
has a design improvement. Basically it's a series of unions as follows:
Select ID, plan_name from table/view
Where plan_name = 'A'
And rownum = 1
UNION
Select ID, plan_name from table/view
Where plan_name = 'B'
And rownum =
There is only one table/view, it's getting one record for each of the
hundred or so plan ID's that I'm looking for.
On 2/13/07 11:29 PM, in article [EMAIL PROTECTED], "Ron Johnson"
<[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SH
On Thu, May 03, 2007 at 02:12:12AM -0700, pumesh wrote:
> may lost. So what should i do to make the backup continuously or during
> these intervals.
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
---(end of broadcast)---
TI
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote:
> Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload
> into 8.2?
http://www.postgresql.org/docs/faqs.FAQ.html#item3.6
---(end of broadcast)---
TIP 5: don't forget to
On Wed, May 16, 2007 at 08:21:59AM -0700, bruce wrote:
> hey.. .
>
> can someone point me to the cmds that i'd use in order to see what databases
> are created in my postgres app. i need to see what's here, and then i need
template1=# select datname, oid from pg_database;
datname | oid
--
fixed now:
* From:
* To: pgsql-novice ( at ) postgresql ( dot ) org
* Subject: SQL for removing duplicates?
* Date: Tue, 13 Jun 2006 12:11:41 -0400 (EDT)
Hi. I'm stumped. I have a large table (about 8.5M records), let's
call it t, whose columns include x and y. I want to rem
it here -
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp?
GL
--
Ray Higdon MCSE, MCDBA, CCNA
---
"Bryant M" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Can anyone reccomend a career path or maybe past experience on a good
> career path
Oliver Elphick wrote:
But as far as Debian is concerned, paragraph 1 applies:
1. Free use for those who are 100% GPL
If your application is licensed under GPL or compatible OSI license
approved by MySQL AB, you are free and welcome to ship any GPL software
of MySQL AB with your application. By "
('category_seq'),
parent id INT DEFAULT '0',
type varchar(50));
Here is the error? What is that all about?
ERROR: Unable to locate type name 'id' in catalog
Thanks,
Ray
-
**** *
lass ?
2. make code reading 'sequence names' live. I looked around pg_class but I
am not sure which relation between reltype,relfilenode,reltoastrelid are
proper ones... So, how to get 'sequence name' by its 'table name' ? Name of
sequence and table are not related (w
Thank you.. I didn't know about race condition.. Shame on me :)
> If you're using PostgreSQL 8.0 or later then you can get the sequence
> name with the pg_get_serial_sequence() function:
Is there any way how to do that (or add this function) in 7.3.x ?
Best regards,
Lada '
on should be possibility to 'begin' transaction, 'store'
somehow on server, and next time, instead of begin new transaction return to
stored one. Transactions solves all these problems, but they don't work
across various/multiple connections
Any ideas/references
urces, talking about this
problem. I didn't find anything usefull around.
Thank you again,
Best regards,
Lada 'Ray' Lostak
Unreal64 Develop group
http://www.orcave.com
http://www.unreal64.net
--
In the 1960s yo
done in 'longer' time - e.g.
hour or so (it take hour to change all datas together) and within various
database connections.
Thx
Best regards,
Lada 'Ray' Lostak
Unreal64 Develop group
http://www.orcave.com
http://www.unreal64.net
-
doing will be used commerically. And
I think, this is general problem, which every bigger system have to solve.
Sooner or later.
I fully agree with you, that locking is not a way. But is there any other
'more automatized' way than take care of row versions by ourself ?
But before contacting
t;ID in (1,2,3...)" with 1500 terms is still 6x
faster rather subselect I really can't get it :)
I understand to output (which corespond with real times) - but don't have
clue, why it's soo differnet. I expect results to be 'similar'. Small
tables, 'fast'
7.4.x and try
all SQL's again. Thank you :)
Please, do you know if exists some 'up-to-date' doc about curret state of
planner ? I didn't found something like that.
Best regards,
Lada 'Ray' Lostak
Un
nternet Services, http://www.cistron-internet.nl (my employer);
look for "WWW server groot" under "zakelijk"
I'm sure there are others, but the usual suspects
http://www.webhosters.nl
http://groups.google.com/groups?as_q=postgresql%20hosting&as_ugroup=nl
Dr. Evil <[EMAIL PROTECTED]> wrote:
> pl/pgsql doesn't seem to be very well documented. It would be cool if it
> were better documented, or if there were a tutorial.
Have you had a look at the materials at
http://www.brasileiro.net/postgres/'
?
Ray
--
I keep
14,20,12,40,34,... it will be fine.
But something like 50, 500, 2000 makes me crazy
I have added 'log' - part of pgsql log coresponding to above SQL.
Feel free to have any Q about sysconfig/programs config.
And sorry again if I miss something.
Thank yo
But the time coresponds
What can I do (or where is some document regarding this topic ?) speed up
PgSql ? I really think, half second for selecting ~100 rows from ~600 rows
table it pretty slow. Commodore 64 (1 mHz 6510) will do it faster :)
Any hints ?
Thanks,
Best regards,
Lada 'Ray&#x
yet released)
contain small chapter / paragraph at LO about this. If someone is new to PG
(like me), there is no enough information about 'using' LO.
Thank you for corrections and comments about LO/columns binary storing.
I hope this email belong to general discussion. If no, I am sorry and
quot;off". How could I do that?
By explicitly starting a transaction through "BEGIN WORK".
HTH,
Ray
--
FUD for dummies by example in 21 days Lesson 3: use braindead analogies.
"Open source raises various security issues. How many banks will tell you
where their
t the OID of an inserted row with
:
:GET DIAGNOSTICS SELECT RESULT INTO ;
HTH,
Ray
--
"The software `wizard' is the single greatest obstacle to computer literacy
since the Mac."
http://www.osopinion.com/Opinions/MichaelKellen/MichaelKellen1.html
tuple length in that version of PostgreSQL.
> (obtained from the log). Can anybody tell me where to find proper
> documentation to raise whatever parameter is necessary to avoid this
> problem?
AFAIK it's not that easy to fix. It is fixed in the beta versions of 7.1.
HTH,
Ray
--
T
oduction
I've not tested it extensively myself, but it passed my lithmus test (import
a database of a couple of million records in one of its tables, with
numerous constraints and indexes, drop some data based on columns which
aren't indexed, then vacuum it [*]).
HTH,
Ray
[*] I've had
t * from pg_" in "psql")
HTH,
Ray
--
Would you rather be root or reboot?
he database is alive and active?
Yes.
>c) Can I backup via pg_dump while the database is alive and active and have
>the backup consistent to the state the database was in when the backup
>started?
The backup is consistent; I assume it's consistent with the state of the
database when pg
_NEXT_LIMITS.H
>#include_next ...
>
>What should i do???
Install the package that contains /usr/include/limits.h . On my Debian
GNU/Linux system, that's the "libc6-dev" .deb; on RPM-based systems I think
it's called glibc-dev.rpm.
HTH,
Ray
--
"My golden rule
ze of 2GB.
Your options to have >2Gb files on GNU/Linux therefore include
- switching to a 64bit platform, say Alpha, Itanic or PowerPC64 or
- switching to a recent (>= 2.1) version of the GNU C library and a recent
(e.g. 2.4.x) kernel.
HTH,
Ray
--
These days we're all supposed to
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>I'm running postgresql-7.0.2-6 on a Debian potato.
Any particular reason why you're not running 7.0.3 (which is the latest
release and contains fixes for some problems with 7.0.2)?
Ray
--
"People should never have been gi
ICE (so it's clear the workaround
occurs) and returns NULL, causing the insert to be ignored.
HTH,
Ray
--
Where do you want to go today?
Confutatis maledictis, flammis acribus addictis.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
sing Oliver's Debian diff for
7.1beta4.
> Might I install plpgsql as procedural language
Yes. Make sure you've installed the postgresql-pl.deb and run createlang(1)
for your databases.
HTH,
Ray
--
Hacker and proud.
---(end of broadcast)--
101 - 200 of 206 matches
Mail list logo
