I am unable to start my PostgreSQL Server.
When I try to start the service I am getting the error below;
System Error 5 has occurred
Access Denied
Where could I be going wrong because it has happened to me more than one
time and what I do is to reinstall PSQL a fresh.
I need a long
I am new to Postgres Administration. I am getting this below mentioned error
in my pg_log and server looks in hanged state whenever this error is getting
logged.
OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server
- Jboss.
2011-11-22 16:57:55 IST LOG: unexpected
Can any one please explain me how to use PITR?
http://lmgtfy.com/?q=postgres+pitr
--
Ian.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
great, thanks. is there any other system function besides string functions?
Come on, it's not that hard! One click away on the link you were given.
http://www.postgresql.org/docs/current/static/functions.html
--
Ian.
On Tue, Sep 27, 2011 at 10:44 AM, Rural Hunter ruralhun...@gmail.com
Attempting to run a backup with the database online. I first issue
'PG_START_BACKUP', then copy the contents of the postgresql data folder,
then issue 'PG_STOP_BACKUP'. The database service remains running during the
copy. If queries continue to hit the database after the PG_START_BACKUP
could do it, in
http://www.postgresql.org/docs/9.0/interactive/continuous-archiving.html
There are other backup strategies too.
http://www.postgresql.org/docs/9.0/interactive/backup.html
--
Ian.
-Original Message-
From: Ian Lea [mailto:ian@gmail.com]
Sent: Friday, April 08, 2011 3:55
I really hope someone can help me with this. All of a sudden this error
is filling my postgres log. I restart Postgres and somewhere around a
minute or two these start getting issued. I have been running this system
for a long time and no changes have been made. Anyone have an idea where
Is there a guide/how to for Postgre 9.0.2 installation/Configuration on a
windows servers (2003 and above)
Have you tried searching? A well known search engine finds about
3,840,000 results for postgres install windows. Or try
http://www.postgresql.org/docs/9.0/static/index.html
--
Ian.
--
At a glance, you may need gunzip -c.
--
Ian.
On Tue, Aug 24, 2010 at 7:22 PM, Tena Sakai tsa...@gallo.ucsf.edu wrote:
Hi Everybody,
I installed a postgres 8.4.4 onto a centos 5.5 machine and attempted to
restore
data from a file made by pg_dumpall. It didn’t work, it seems. What I did
http://www.postgresql.org/docs/8.4/static/high-availability.html would
be a good place to start research. And the archives of this thread
would be another - there are recent messages about this sort of thing.
And google postgres high availability or equivalent.
I use slony but there are plenty
pg_dump and restore are typically fast. Have you tried other -F
values? c does compression which, in your case, on your servers, might
be slow. You could also try running the dump on the server that is
hosting the source database, copying the file across and loading it on
the target server. Or
I'm still confused about the disk space, even more so now that more
servers and figures of 1Gb and 15Gb have joined the party.
Presumably this:
3.6M./1
3.6M./16975
51G ./95186722
4.8M./4830693
51G .
is the output from some $ du command. And is this
-rw---1
The most likely cause is surely application error: your application is
attempting to insert rows into a table and those new rows have the
primary key set to a value that is already present for that table.
Could be the app isn't checking properly before doing an insert (or
update), could be you are
In your original email I think you showed a directory that held
something like 50Gb of files with a listing of that directory that
added up to something much smaller. If that is right - what else is
in that directory?
Does your monthly vacuum script work?
--
Ian.
On Wed, May 5, 2010 at 2:42
It is unreasonable to expect 8.3 programs to be able to understand
everything that 8.4 programs might write.
What format is your dump in? Plain text (--format=p) might work. Or
try dumping the 8.4 database with the 8.3 version of pg_dump, or maybe
use the 8.4 pg_restore against the 8.3
test= select round(54.11238742, 3);
round
54.112
is maybe what you want.
P.S. pgsql-admin list is for postgresql admin questions.
http://www.postgresql.org/community/lists/
--
Ian.
On Fri, Feb 5, 2010 at 7:35 AM, Hyung Joo Lee procar...@imrc.kist.re.kr wrote:
Dear all.
I
From $ man postmaster
-i Allows remote clients to connect via TCP/IP (Internet domain)
connections. Without this option, only local connections are
accepted. This option is equivalent to setting listen_addresses
to * in postgresql.conf
restoring objects.
I hope this gives you more to go on. I have included the log of the pg_dump
and restore.
Best regards:
Baubak
-Original Message-
From: Ian Lea [mailto:ian@gmail.com]
Sent: mardi 1 décembre 2009 18:31
To: Baubak Gandomi
Cc: pgsql-admin@postgresql.org
You could start by saying what version of postgres, on what OS, and
posting your backup and restore commands with any output, error or
otherwise, that they produce.
--
Ian.
On Tue, Dec 1, 2009 at 4:48 PM, Baubak Gandomi
b.gand...@castsoftware.com wrote:
Hello,
I have a problem restoring
1) Exactly the database was at 10:15 am
From http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
There is nothing that says we have to replay the WAL entries all the
way to the end. We could stop the replay at any point and have a
consistent snapshot of the database as it was at
1) What is the advantage / disadvantage of setting archive_timeout command
to too small or too high value?
The advantage of setting it high is that you'll use less disk space
and have fewer files to archive.
The disadvantage of setting it high is that you might lose more data.
In your 30
21 matches
Mail list logo