I am getting the following error when I go to Application -> PostgreSQL ->
Reload Configuration
"
Please enter your password if requested.
pg_ctl: PID file "/home/Jen/Installed/PostgreSQL/data/postmaster.pid" does
not exist
Is server running?
Press to continue...
"
I have installed Postgresql f
Hi,
I have finally found out why I have had images that lag on the website. It
seems to be that postgre is doing allot of I/O activity and the images is
somehow suffering because of this.
The strange part about this is that it seems to be allot more disk writes
than disk reads. Even though 99.9% of
I accidentally replied only to Grzegorz before so I don't think it turned up
on the mailing list. Here it is again. (Bill, I will try to answer your
email in a minute) ---
Thank you for you answer :)
2009/6/3 Grzegorz Jaśkiewicz
> move postgresql to another disc if possible.
I have 2 disks that
On Wed, Jun 3, 2009 at 5:13 PM, Bill Moran wrote:
> In response to Jennifer Trey :
> >
> > I have finally found out why I have had images that lag on the website.
> It
> > seems to be that postgre is doing allot of I/O activity and the images is
> > somehow suff
lol, if I had a nickel for every one that said they had a dollar I'd buy a
Ferrari F430 :P
but I do.. most of my memory isn't being used.. and I have once had a deep
discussion on tuning postgres on this mailing list. Feel free to search on
my name and you will see it :)
But I have gotten even clos
Sorry.. the formatting got screwed.. here it is again :
-
lol, if I had a nickel for every one that said they had a dollar I'd buy a
Ferrari F430 :P
but I do.. most of my memory isn't being used.. and I have once had a deep
discussion on tuning postgres on this mailing list. Feel free to search
issue.
Are you sure that moving to Linux will solve this? Could you please check if
you notice the same write behavior? Any other windows users that noticed
this?
Thank you in advance / Jennifer
On Wed, Jun 3, 2009 at 8:32 PM, Jennifer Trey wrote:
> Sorry.. the formatting got screwed.. here it
On Wed, Jun 3, 2009 at 10:59 PM, Bill Moran wrote:
> In response to Jennifer Trey :
>
> > Hmm, I just noticed the same write behavior on my Windows Xp laptop but
> the
> > values was a little less.
> > I even created an DB with one table and column and this still ha
Bill, did you see my last message on the mailing list? I have tracked down
the file. Is this some statistics file? Could this be a bug caused by auto
vacuum being on?
Hmm.. I doesn't look it made it to the mailing list. I guess you can't
attach a file then.
Finally!
I did use the programs suggested by Michael, but I actually found it a
little before you wrote :P
Filtering out with the pid showed that it was the file
pgdata/global/pgstat.tmp
See the attache
The research is based on hypotheses and assumptions which in the end can
be discarded or not. I do not know these things, I am taking one step at
time, learning and trying.
I don't understand what kind of research you want me to do. I don't have any
performance problem other than that images seems
Sorry, went to bed yesterday :D
I have installed postgresql-8.3.7-1-windows.exe
Bill, you are right. The app does do tons of small queries, and its possible
that the two drives are misconfigured. I have checked into that a little and
can't rule it out completely.
Yes, my images hang indefinitly,
No, I don't have any virus programs installed.
Bill, you wrote earlier :
"
Additionally, this convinces me further that you're chasing the wrong
problem. The stats collector writes tiny bits of information to disk
every time you execute a command. If your system is slow because of this
tiny bit
Hi,
What file should I be working with?
Thanks in advance / Jennifer
Ook.. thats what I wanted to know. I figured there has to be a place to
change the pointer to the new location of the data.
Thank you / Jennifer
On Thu, Jun 4, 2009 at 6:11 PM, Bruce Momjian wrote:
> Jennifer Trey wrote:
> > Hi,
> > What file should I be working with?
>
&g
On Thu, Jun 4, 2009 at 4:58 PM, Bill Moran wrote:
> In response to Jennifer Trey :
> > Bill, you wrote earlier :
> >
> > "
> > Additionally, this convinces me further that you're chasing the wrong
> > problem. The stats collector writes tiny bit
Reporting back.. no.. I tested the track_count and autovacuum and the writes
where back.
/ Jennifer
On Thu, Jun 4, 2009 at 6:54 PM, Jennifer Trey wrote:
>
>
> On Thu, Jun 4, 2009 at 4:58 PM, Bill Moran wrote:
>
>> In response to Jennifer Trey :
>> &
Hi,
I would like to run a query and group several rows based on a phone number.
However, the same phone number might have a prefix on occasion, example :
name | phone_number
--
james | 123456
james | 00441234556
james | 555666
sarah | 567890
sarah | 567890
as you can see, th
Sorry for taking so long to respond. The prefix thingy is definetly
attractive for future development and I had already discovered them to be a
challenge. However, i have noticed all kinds of ways people tend to write
their number, including omitting the + or 00 .. so at this time, for this
task, I
Hi,
I have been running PostgreSQL 8.3 for a while now and was installed through
the standard Windows installer and everything has been working great :)
I am in the process of switching to Ubuntu, and I have a couple of question
to get started. I installed pgadmin and postgre through the Synaptic
Thanks, I got help from a friend and got it to work. I think postgre was
running already but not sure what else he did.. i think that he altered the
password among other things.
How should one port the config file from windows to linux? I am guessing
replacing the .conf file is not an option :O ..
I have been using Windows before and that was just an installer. How can I
install and run something similar on Ubuntu ?
Thanks / Jen
Is this it?
http://pgfoundry.org/projects/pgtune
I thought it was EnterpriseDB. Perhaps that's only for windows?
Thanks / Jen
Unfortunately I used the apt-get utility. So I might have missed out on
those packages. But I un-installed (I hope I got everything) and deleted
some folders, got the one click installer and re-installed. I got everything
now and set up postgre and it is working fine. However (something I ran
int
Hi,
First I installed postgres using the apt-get utility on ubuntu, and then
later uninstalled it to install postgres though the one-click installer.
Trying to find the share folder i ran pg_config and it shows the old path
: /usr/share/postgresql/8.3
I have a pg_config under my new installation
Just another try on TuningWizard.
I tried running it from console :
r...@ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard#
./TuningWizard
./TuningWizard: error while loading shared libraries: libexpat.so.0: cannot
open shared object file: No such file or directory
And :
r..
Thank you for your answer.
I did export the LD_LIBRARY_PATH and now the complain is something else..
progress :)
Error: Unable to initialize gtk, is DISPLAY set properly?
I have also launched the TuningWizard from an icon and I got to the step
(development, mixed, dedicated) as before and then th
Yes, you are right. I didn't stop the server before un-installing. Not good.
I should have thought about that. Not sure how to repair that though.
running pg_config :
r...@ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard#
pg_config
BINDIR = /usr/lib/postgresql/8.3/bin
DOCDIR
On Fri, Jul 31, 2009 at 3:02 AM, Daniel Verite wrote:
> Jennifer Trey wrote:
>
> > >> locate pg_config
> > /opt/PostgreSQL/8.4/bin/pg_config
> > /opt/PostgreSQL/8.4/include/ecpg_config.h
> > /opt/PostgreSQL/8.4/include/pg_config.h
> > /opt/PostgreS
Hi,
I wanted to start with the TuningWizard and then configure the one they
suggested, thinking that I am starting from good default values.
But I am not able to run TuningWizard for some strange reason, but I am
actually mostly interested in some few settings that it usually provides.
Especially
On Fri, Jul 31, 2009 at 12:29 PM, Thomas Kellerer wrote:
> Jennifer Trey, 31.07.2009 12:17:
>
>> Hi,
>>
>> I wanted to start with the TuningWizard and then configure the one they
>> suggested, thinking that I am starting from good default values.
>>
>>
advance / Jennifer
On Fri, Jul 31, 2009 at 12:48 PM, Magnus Hagander wrote:
> On Fri, Jul 31, 2009 at 12:35, Jennifer Trey
> wrote:
> > On Fri, Jul 31, 2009 at 12:29 PM, Thomas Kellerer
> > wrote:
> >>
> >> Jennifer Trey, 31.07.2009 12:17:
> >>>
Is autovacuum on by default?
or do I uncomment
#autovacuum = on
and
#track_counts = on
to enable it? Anything else I should do?
Thanks / Jennifer
On Fri, Jul 31, 2009 at 1:10 PM, Jennifer Trey wrote:
> Ok. I will.. when it comes to the other settings, like autovacuum and such.
> C
I think I got everything now. Most things where on by default it seems.
#--
# RUNTIME STATISTICS
#--
# - Query/Index Statistics Collector -
tra
Hmm.. not done quite yet it seems :(
I tried initially to set shared_buffers to 1024MB but I got this message :
2009-08-01 15:04:46 CESTFATAL: could not create shared memory segment:
Invalid argument
2009-08-01 15:04:46 CESTDETAIL: Failed system call was shmget(key=5432001,
size=1106247680, 036
For 1024MB = 1024*1024*1024 bytes
kernel.shmmax=1073741824
and for ceil(1073741824)/4096) = 262144 which is actually much smaller than
the setting that is the default ( 2097152 )
But setting these two to the values above still gives similar error and the
pg-server still doesn't start.
2009-08-01
I can't figure out the correct syntax...
I have this, but it just keeps complaining about the IF
IF NOT EXISTS (SELECT table_name FROM information_schema.tables where
table_name = 'post_codes')
THEN
CREATE TABLE post_codes
(
area character varying(10) NOT NULL,
district character varying(10
You all make it sound so easy :)
How do I write the above using a function?
Cheers, Jen
exception and catch it ? Write a function
for this would be optimal, although I have no idea what the correct syntax
is.
Cheers, Jen
On Mon, Jul 19, 2010 at 5:58 PM, Joe Conway wrote:
> On 07/19/2010 09:33 AM, Jennifer Trey wrote:
> > I can't figure out the correct syntax...
>
Thanks guys.
Joe, I tried ( and learned! ) from your syntax. I didn't have pgsql language
installed but I googled it and figured that part out.
There was an issue with using your way though, you see the constraints
relation also needs to be considered, as if a constraint key already exist,
for an
I am new to postgreSQL and I am running queries from JAVA and would like to
see what queries are being run.
How can I achieve that ? I am running PostgreSQL 8.3 on Windows and like
using pgAdmin to do most things.
Jennifer Trey
Which one should one install? Is there any difference?
They are both free right? And both has fulltext support, right?
Jen
I am sorry, but it seems that I replied to only one of you instead of to the
mailing list.
I am just about to install a version on my "Server computer" (Windows web
server 2008 x64) and I am stuck on what I should go with.
I have been developing on the standard postgreSQL but like that the
Enterpr
PM, Jennifer Trey
> wrote:
> > I am sorry, but it seems that I replied to only one of you instead of to
> the
> > mailing list.
> > I am just about to install a version on my "Server computer" (Windows web
> > server 2008 x64) and I am stuck on what I should
Point me to latest JDBC for pgSQL (plus) standard server?
Hi,
During the development of my application I once, somehow through an
installed postgresql software got me to a page where I could find
information on how to tune my db.
I can't seem to find to that link again. I think it was to a page within the
EnterpriseDB but that page seems to have significa
I even wrote down the password when I installed the DB and now it doesn't
work!
I have logged in once to the DB through pgAdmin, and choose to store the
password and it said that it was stored in plain text.. where can I find it?
in what file?? I even created a DB that I haven't used yet so I am c
It is still stored..and I got hold of it.. I used it and it is not workin!?
What could be the problem? How should I log in?
See the picture I attached...
On Wed, Apr 1, 2009 at 10:16 PM, Jennifer Trey wrote:
> I even wrote down the password when I installed the DB and now it doesn'
I am using pgAdmin, and that file I accidentally attached instead of an
image I was planning to attach..
On Wed, Apr 1, 2009 at 10:40 PM, Raymond O'Donnell wrote:
> On 01/04/2009 20:16, Jennifer Trey wrote:
>
> > Most importantly, where can I find the password if it was stored
...
and also, I found it (the password) but I cannot log in with it anyway...
/ Jennifer
-- Forwarded message --
From: Jennifer Trey
Date: Wed, Apr 1, 2009 at 10:47 PM
Subject: [GENERAL] Installed PG with pgAdmin, some days later, now my
password don't work!
To: pgsql-ge
By the way, yesterday I used the TuningWizard too, could it have changed
some of these things? It does create a new config file.. is it possible?
On Wed, Apr 1, 2009 at 10:50 PM, Jennifer Trey wrote:
>
> Sorry, for the confusion.. just want to make something I wrote more clear:
>
>
Hi, I am trying to create my DB schema on the server through my development
laptop.
I have installed Web Server 2008 and PostgreSQL. They are both running. For
some reason its not working. Do I need to open some firewall ports?
PostgreSQL runs on 5432. ( I think I did that though). Do I need to
con
no pg_hba entry for host 85.235 user postgres, database xxx .. ssl off
...
?? I guess that means that I need to set up pg then..
how is the question now :)
/ Jen
On Sun, Apr 5, 2009 at 8:35 PM, Raymond O'Donnell wrote:
> On 05/04/2009 19:28, Jennifer Trey wrote:
> > Hi,
Hi,
What does the Tuning Wizard do? The one you can run on PGS ? Does it just
touch up the postgresql.conf ? Does it play with other stuff as well?
I am asking because, every time I run the wizard I cannot login with the
password I choose when I installed PGS. What is going on? Replacing the
gener
hat is going on. Server refuses to start it seems. Please help me
debug this problem :)
Sincerely / Jen
On Wed, Apr 8, 2009 at 2:31 PM, Dave Page wrote:
>
> On Wed, Apr 8, 2009 at 12:16 PM, Jennifer Trey
> wrote: > Look, I am telling now what I did. > > I don't want to hear
Look, I am telling now what I did.
I don't want to hear claims about how its not the tuning wizards fault. It
is!
And it does more than the postgresql.conf because thats not true.
Just until today I have been able to login and logout, using pgAdmin to my
DB.
Now, after considering what you said,
I just tried to change the permission on all users, admin to user to
postgres. Access Denied for all! The machines have taken over!
It seems like my long message didnt make it :S Here it is again. (Perhaps it
was because of the attached pic, I will leave it out this time)--
On Wed, Apr 8, 2009 at 3:17 PM, Massa, Harald Armin wrote:
> Jennifer,
>
> obviously you are on windows. And the problem you are describing seems to
After doing allot of clicks with the permissions. It automagically fixed
itself. Fantastic!
The root problem was Windows itself!
I would recommend the EnterpriseDB folks to consider this though, because in
someway its affecting your software.
Thank you all. Now join my new thread for real discus
Ok,
I have left the previous thread. After changing the last permissions, even
though it said Access Denied, suddenly PostgreSQL started to work again. I
will not dig any further to the strangeness.
I copied the content of the.conf from tuning wizard and restarted. Still
working!
I want to say t
On Wed, Apr 8, 2009 at 5:23 PM, Bill Moran wrote:
> In response to Jennifer Trey :
> >
> > I have 8GB memory, Intel Quad Core 2.4Ghz with 8MB L2 cache. I am running
> > Windows Web Server 2008 x64 and will be running a Java (64 bit version)
> > application.
> >
On Wed, Apr 8, 2009 at 5:38 PM, Massa, Harald Armin wrote:
> Bill, Jennifer,
>
> > *shared_buffers = 1024 # min 128kB or max_connections*16kB ## Also to
>> low.
>> > Right? I've got 3GB to work with!*
>>
>> Assuming that's equating to 1G, then the value is about right. Common
>> best practice i
max_connections = 150 # A comprimise :)
effective_cache_size = 2048MB # Old value 439MB --> Even older : 128MB
#Is this too high?
maintenance_work_mem = 96MB # Old 16MB. Would 64MB be better? Updates
and therefore re-indexing of tuples happens quite frequently.
work_mem = 3MB
# Old was 1MB!? Tha
Scott, thank you.
I think I might have misunderstood the effective cache size. Its measured in
8kB blocks. So the old number 449697 equals 3.5 GB, which is quite much.
Should I lower this? I had plans to use 2.75GB max. Can I put 2.75GB there?
Should I leave it?
Also, Greg. Since I use Java, pre
nice :)
Is the effective cache only the one for the OS ? not for them combined ?
Sincerely / Jen
On Wed, Apr 8, 2009 at 7:44 PM, David Wilson wrote:
> On Wed, Apr 8, 2009 at 12:24 PM, Jennifer Trey
> wrote:
>
> > I think I might have misunderstood the effective cache size. Its mea
65 matches
Mail list logo
