Hi,
Have you defined an archive_command ?
What is your value for checkpoint_segments, checkpoint_timeout &
checkpoint_completion_target ?
Thomas
Le 26/08/2013 05:10, Ed Tarento a écrit :
Hi admins
I'm a newbie, I hope this is the right group and admit I have little
postgres e
Manish Kediyal wrote on 29.07.2013 09:17:
I have various DB in my DB cluster, i want to vacuum all DB's using a shell
script.. scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to vacuum
all DB's
Is there a specific reason you don't want to use auto-
Technical Doubts wrote on 20.06.2013 09:42:
technologies
(
technologyid bigint,
status character(1),
implementeddate date
*CONSTRAINT technologies_uq UNIQUE (technologyid, status, implementeddate)*
)
entering data as
insert into technologies (technologyid,status,implementeddate)
values
(123,'P'
Szymon Guz, 06.05.2013 20:25:
That's strange. I've never met any newsgroup which would require top
posting. Top posting has always been considered rude.
We are reading from top to bottom. That's why people should answer
below cited text, so we can read it later normally. I mean that I
should re
Campbell, Lance wrote on 14.02.2013 20:09:
PostgreSQL 9.2
When creating a table or altering a column of a table, is there a way
to add notes on a column?
comment on table foo is 'the foo table';
comment on column foo.bar is 'the bar column';
http://www.postgresql.org/docs/current/static/sql-
Thomas Kellerer wrote on 12.09.2012 11:09:
Is there a way to find out which function (or extension?) is using those
libraries in order to remove that dependency?
What I ended up doing is to search through my pg_dump backups and I found the
"offending" database.
After removing the
allow me to
install them. They weren't installed with the installer and they are not part
of the Windows ZIP distribution either.
Any ideas?
Thanks in advance
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi,
give db visualizer a try.
best regards
Thomas
Am 04.09.2012 18:35, schrieb Craig James:
Can anyone recommend a good tool for producing a good drawing of an
existing database schema? I don't need a design tool, but rather one
that can take an existing schema and produce a nice di
Hi Craig,
thanks, that was the tip
a rollback prepared on these does the job
best regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
work?
no, its a live system with normal olap access
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
to cluster, reindex and vacuum (+full) pg_class without success
psql MYDB -c "vacuum verbose pg_catalog.pg_class"
fast system:
INFO: "pg_class": found 1 removable, 2106 nonremovable row versions in
45 out of 45 pages
DETAIL: 0 dead row versions cannot be removed yet.
other
m user_view
where name = 'foo'
and password = 'bar'
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
remains in
IDLE IN TRANSACTION mode. Please ensure that you invoke a COMMIT after
each successful request or ROLLBACK after failed or control these inside
your application. I'm not familiar with pgpool but check if you can
configure your pooler for this behaviour
Thomas
Am 03.05.2012
tkmap
is what you want. See
http://www.postgresql.org/docs/9.1/static/auth-methods.html#AUTH-IDENT
I still get an authentication error but probably that's because ident is indeed
not available on Windows.
It's not that important as I just wanted to play around with it.
Thanks f
Ideally I would like to make "ident" to work with a custom map but using "ident tkmap".
But that throws the same error which isn't really surprising as "ident tkmap" is not working either.
Is ident not supported on Windows? I could not find anything related t
Bèrto ëd Sèra wrote on 01.05.2012 11:13:
Hi all,
I'm asked to benchmark a PG-related product. I was wondering if there
is any "sort of standard" public dataset for such operations. The one
and only limit I have is I cannot use triggers with this product
(otherwise I'd use a copy of our own produ
Wells Oliver, 22.04.2012 00:58:
Is there a way to get the date that starts week 14, or 15 (etc)?
Try this:
select to_date('201214', 'iyyyiw')
That uses the ISO week definition.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www
ЇЯЅHAÐ wrote on 17.04.2012 01:27:
Hi,
We are trying to migrate from Postgres to Oracle, although our DB is gigantic
but we started on Mar 14th 2012 & its still running with an average of 40
records per day
How can we check what is going wrong.
Any memory leak, CPU issue or anything.
If y
Scott Marlowe, 05.02.2012 23:13:
Not sure what you mean by "community edition". There's PostgreSQL.
From the postgresql.org website, which is what most folks use.
I think the term "community edition" was coined by EnterpriseDB - at least it
shows up on their webpages on some places.
--
S
NOT NULL.
Is it possible to create a CHECK constraint for my use case explained above?
Something like this:
check ( (managertype = 2) or (managertype = 1 and managerid is not null) )
Not sure if the condition (managertype = 2) is actually needed, if the
managertype is already constrained to 1
Hi,
thats possible. Dont forget so set another port in your postgresql.conf
Thomas
Am 13.12.2011 09:23, schrieb Selva manickaraja:
Hi All,
We are planning to create a 2nd instance of postgres db in the same
server. The reason is simple. After we added another application, the
number of WAL
PresleyDias wrote on 21.11.2011 08:54:
i want to create a postgres database using batch file, now the normal way of
doing this is
"C:\Program Files\PostgreSQL\9.0\bin\createdb.exe" -U Myadmin MydatAbseName
this create a database with the default database parameters, but i want to
create a datab
Rural Hunter, 27.09.2011 11:00:
I am looking for something like a string hash function to order a string cloumn
randomly.
It's all in the manual ;)
http://www.postgresql.org/docs/current/static/functions-string.html
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresq
is "hanging"? The client that retrieves the data or
PostgreSQL itself?
So I'm not sure how to find these bad records and why I am getting a
hang.
If your client application is hanging, I don't think there is a single "bad"
record, it just chokes on the size of t
Hi Greg,
Yeah, thanks a lot. Works perfect. The correct perl code is:
my $backupargs = sprintf("-f \"%s\" -F p --clean -U postgres -h
localhost %s", $backupfile, $DBName);
Cheers
Thomas
Am 09.06.2011 22:16, schrieb Greg Sabino Mullane:
-BEGIN PGP SIGNED MESSAGE-
means it finds it in the password file.
Does anybody see what the heck I am doing wrong here?
Many thanks for your help!
Thomas
Didik Prasetyo wrote on 07.05.2011 09:28:
I want to ask how to make GRANT, where users can only perform SELECT
on all the TABLE, in the database, which I have done the following
You might consider upgrading, because since 9.x you can do:
GRANT SELECT ON ALL TABLES IN SCHEMA public;
Thomas
jtke...@verizon.net wrote on 02.05.2011 18:52:
I've just started working on an 8.4 database and I have been asked to
extract all the functions source code stored in various databases and
schemas so they can be put into a repository for the developers. I'm
planning to use pg_get_functiondef(OID
her method for alter column to bigint.
This should do it:
ALTER TABLE test ALTER column time type bigint USING extract(epoch from time)
(Btw: I would avoid column names that are keywords like "time")
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
LE '||table_name||' DROP CONSTRAINT '||constraint_name||';'
FROM information_schema.constraint_table_usage
to a file, and then run that file to drop all constraints.
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Sairam Krishnamurthy, 15.02.2011 23:43:
Again,
pg_ctl: could not open PID file
"/media/extension/var/lib/postgresql/8.4/main/postmaster.pid": Permission denied
Tried all the different ownership possible.
And you are sure you ran that as the postgres user?
Thomas
--
Sent via p
Gnanakumar, 03.02.2011 13:00:
Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar
to multirow VALUES syntax available for INSERT?
INSERT Multirow VALUES syntax example:
INSERT INTO films (code, title, did, date_prod, kind) VALUES
('B6717', 'Tampopo', 110, '1985-02-10'
hi,
looks like a 32bit version so 4294967293 is too much (4GB). Use a 64bit
version
regards
Thomas
Am 04.01.2011 14:48, schrieb Victor Hugo dos Santos:
Hello,
Actually I use postgresql version 8.4.6-0ubuntu10.04 in bacula server
to save information about backups from bacula.
But, 2 days
Joe Carr wrote on 19.10.2010 00:55:
Hi Thomas, Thanks for your reply. pg_ctrl has given me some more
information, but I'm not quite there yet.
I have verified that the postgres user has "full control" access to
the data directory.
When I take the commandline from the service
any
database and hit backup for that database it does not give me any
error message but it hangs at that point. To fix this i have to
restart the pgadmin.
Did you try to use pg_dump directly instead of pgAdmin?
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
u Picciano
If you are looking for a commercial tool, dbWrench is pretty good and
reasonably priced.
The only usable open source/free tool that I know of is PowerArchitect
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscrip
ould use psql to
run a single statememt.
Something like:
psql -c "create role new_role with password 'new_roles_password'"
(You might need to play around with the quoting)
The environment variables are then used to establish the connection to the
correct Postgres instance
might work:
- snip ---
@echo off
setlocal
set PGHOST=localhost
set PGUSER=postgres
set PGPASSWORD=the_super_secret_password
createuser role_1 1> nul 2>&1
createuser role_2 1> nul 2>&1
...
endlocal
- snip ---
Regards
Thomas
-
's a permission issue with the data directory. Did you
verify the postgres user (the one under which the service is started) has full
access to the data directory?
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http:
those
environments exposes many differences.
I had no problem setting up a proof-of-concept on my Windows laptop with
streaming replication and both instances running on my computer. The batch
files needed were quite simple.
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin
nd to read it. Its available
here:
http://www.linuxtechnicalreview.de/Vorschau/%28show%29/Themen/Datenbanken/PostgreSQL-erweitern
Bests
Thomas
--
Thomas Uzunoff
Linux New Media AG, Putzbrunnerstr. 71, 81739 München, Germany
Phone: +49 89 9934 1137 Fax: +49 89 9934 1199
tuzun...@linuxnewmed
n a differend harddisk (or storgae system) as the
data directory, I'd reckon it wouldn't have much impact on the primary server.
Or am I missing something?
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
t;standby" (i.e. recovery) mode
If I use "pg_ctl stop" it never shuts down.
If I use "pg_ctl stop -m immediate" most of the postgres processes terminate,
but the one that spawned the pg_standby process will linger around.
What am I missing here?
Thanks a lot in advance
ld essentially overwrite
that transaction in the WAL.
Currently our "favorite" is file system replication between two nodes.
The target system will be Solaris using a ZFS filesystem.
Are there any Solaris/ZFS specific features that would help here?
Thanks again for the inp
question might sound a bit stupid: from my point of view solutions using shared
disk failover of file system replication seem to be more reliable in terms of
how much data can get lost (and possibly the switch over lag)
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgres
ctions are lost?
Regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
r potential data loss) I would
rather go for 8.4 than 9.0 just because the feature is so new in 9.0 and might
not be 100% reliable at the beginning.
Any input is highly appreciated.
Thanks in advance
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make chan
follow the advice above the registration form
and download it directly using the link in the word "here" in the sentence: "Your
download will begin momentarily, please click here if it doesn't start in the next few
seconds."
Thomas
--
Sent via pgsql-admin mailing
it's just one (regular) bulk
import that does some heavy writes which we need to tune. Read performance is
absolutely fine, but everything around vacuum and checkpointing seems to slow
down the import massively.
So would taking a snapshot before and after this import be the right way to
Greg Smith wrote on 08.06.2010 19:30:
Thomas Kellerer wrote:
If I want to identify a possible bottleneck with the bgwriter, for
what kind of numbers do I need to watch out?
You don't much with a single snapshot of pg_stat_bgwriter data. Try
saving this instead:
select *,now()
t I
don't understand the explanation. He mentions a "LRU background writer", but
I'm not sure to which column that relates.
Thanks in advance.
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
data folder
- Do an initdb --locale=sv_SE.28591 -U postgres
- Start the service again
Is there an easier way? Is there an easy way to make a custom installer?
Kind Regards,
Thomas Hallgren
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to you
html
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
an alternative use a GUI tool that does this for you
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ER "PepeArgento";
While one can certainly do that, I would strongly discourage the usage of mixed
case user names (or any other object name that is). I'm pretty sure that will
cause more trouble than it's worth.
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@post
?
I appreciate any help you can give me!
Thomas
(Sent this before I subscribed to the list. It looked like not being
subscribed was holding up the post. I don't mean to spam you with
reposts; sorry for any trouble)
---
Thomas Houfek
Project Manager, Center for Stem Cell Bi
ttach to shared memory" errors was fixed. I don't know if this
is the same what you are seeing.
http://www.postgresql.org/docs/current/static/release-8-4-1.html
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www
Andreas Wenk wrote on 16.07.2009 11:14:
dayat schrieb:
Hi pgsql admins,
I think the postgresql 8.4.0 binaries-no-installer for win32 exists in
http://www.postgresql.org/ftp/binary/v8.4.0/win32/ . Who are know
where I can to get this file.
EnterpriseDB also provides a ZIP archive of the binari
sufficient pam_ldap.so
This suggests some problems accessing some pam-related file but I cannot
imagine which one?
The server runs on Debian 5 by the way.
Any pointers would be highly appreciated - the PostgreSQL documentation is
pretty thin on this..
Thanks!
Thomas
er runs on Debian 5 by the way.
Any pointers would be highly appreciated - the PostgreSQL documentation is
pretty thin on this..
Thanks!
Thomas
Dear,
I am new user of Postgre. When i try to install postgre(window 8.3) its
asking for root password, even though i given the admin password its show
that the password is incorrect, Please help me this
--
Prijith Jacob Thomas
hi,
i assume you have a 32bit system so you cant set shmmax to 4gb. as a
side effect your value 4294967296 in a binary 32bit representation is
exactly 0. look for previous threads about shmmax. and use a 64bit system :)
regards
thomas
Nicolas Michel schrieb:
Hi here,
Our server had 2GB of
in,
you likely simply don't use your newly built postgres. Check paths
and start scripts and make sure, it uses your new built binaries.
If that's not it, I think you have to provide more information about
your platform.
Ciao,
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@p
order by the time was jus
1 or 2 seconds ... on this installation the time it's about 10 seconds or
more",
could you provide the "explain analyze"-output for those queries? This should
help analyzing your problems.
Ciao,
Thomas
--
Thomas Pundt http://
hi,
try
set PGOPTIONS="-c default_tablespace='pgdata'"
regards
thomas
jan-peter.seif...@gmx.de schrieb:
Hello,
without success I tried to set the default tablespace via the environment
variable PGOPTIONS.
My tries:
set PGOPTIONS="default_tablespac
hp) so theoretically she could probably do it.
That reminds me having seen something like a shell implemented in PHP:
google for php-shell. I've never used such a beast, though.
Ciao,
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
aje original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] En nombre de Carol Walter
> Enviado el: lunes, 15 de septiembre de 2008 02:58 p.m.
> Para: Thomas Jacob
> CC: Barbara Stephenson; pgsql-admin@postgresql.org
> Asunto: Re: [ADMIN] open source ERD for postgresq
I've been using GNU ferret for a while, it's OK
for simple tasks, and can produce table graphs and
even output rudimentary PostgreSQL DDL in Version 0.6,
but it doesn't support PostgreSQL's full range of types yet
and the handling is somewhat awkward.
Version 0.7 looks much more promising, at leas
?
Like finetuning of...
- fsync
- wal_sync_method
Thanks if someone can help me on this.
Cheers Thomas
?
Like finetuning of...
- fsync
- wal_sync_method
Thanks if someone can help me on this.
Cheers Thomas
pg_log isn't a standard postgres dir,
so maybe it's where RHEL stores the
actual textual log files that the
server process generated.
Indeed this is suggested here:
http://www.nabble.com/-GENERAL--pg_log-missing-td7753209.html
So if these files look something like:
2008-08-03 00:30:47 CEST LOG:
> BTW, I'd encourage you to start a page on the wiki site to track the specific
> issues you run into, and specific fixes your using. Would certainly be
> helpful to others and probably yourself as a reference on the topic.
I've started a page as you suggested which at the moment contains only
On Mon, Aug 18, 2008 at 10:49:49AM -0600, Scott Marlowe wrote:
> On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote:
> > I've changed my approach by revoking rights to schema public
> > from PUBLIC in the template1, and then granting all rights
>
On Mon, Aug 18, 2008 at 10:55:27AM -0600, Scott Marlowe wrote:
> On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote:
> > On Mon, 2008-08-18 at 11:48 -0400, Robert Treat wrote:
> >
> >> Yes, I think the whole "security through obscurity"
On Mon, 2008-08-18 at 11:48 -0400, Robert Treat wrote:
> You'll likely want to make the database owned by that role.
My intention is to have some sort of "main"-user who'll be
able to do whatever they want (because they create
all the objects) and a number of additional users
that only have the r
ported version (1.10) in file header"
When I use a 8.1.11 pg_restore, it seems to work fine.
But that's hardly a suprising result.
Thomas
signature.asc
Description: Digital signature
On Thu, Aug 14, 2008 at 12:06:53PM +1000, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I am curious as to why a pg dump of database "name" is 2.9gig. But is
> measured at 1.66gig by:
> SELECT pg_database_size(pg_database.datname) AS db_size FROM pg_database
> WHERE pg_database.datname='name' ;
>
> This
Thanks for your reply.
On Wed, 2008-08-13 at 08:57 -0600, Scott Marlowe wrote:
> Well, databases are designed to be accessed by people you trust to not
> do really stupid things that can affect the other users.
Well, in a shared hosting scenario this hope can easily
turn out to be in vain, but s
g the right from pg_catalog doesn't
seem to be an option, as this breaks
several features of the psql utility and probably
other things.
Thanks & Best Regards,
Thomas
signature.asc
Description: This is a digitally signed message part
o you think I can reach the target
with a snapshot and also keep in mind the size of the DB?
Cheers Thomas
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tino Schwarze
Sent: Montag, 30. Juni 2008 15:36
To: pgsql-admin@postgresql.org
Subject: Re: [
Hi Tino,
Why avoid RAID5? I though that would be good? Can you explain this?
Writing in the DB, I add about 5-10 GB of data a day. There is a lot of writing
activity going on in the database every day.
What do you recommend how often I should backup the complete database?
Cheers Thomas
feedback and Cheers Thomas
Hi Robert,
That's the issue, the database is not running which gets delivered with Solaris
10 but I am not sure if the my customer accidently activates it or not, so I
want to be on the safe side of live, that I minimize this risk.
Cheers Thomas
-Original Message-
From: [
Is this than everyhting I need to take care when I run this both standard
databases or do I need to configure or change something else?
unix_socket_directory = 'data directory for a particular DB here'
listen_addresses = 'VIP here'
port = 5432
Cheers Thomas
-Origin
Hi Jignesh
What things do I all need to take care when I want to run both postgres
databases on the same box. Like the Solaris 10 postgres db and my postgres db.
What parameters to I need to change in the postgresql.conf file? Is there
something else I need to take care?
Cheers Thomas
Thomas
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 02:33
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10
On Wed, 30 Apr 2008 01:59:08
Hi Joshua,
Why does it affect shmmax?
Cheers Thomas
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 01:52
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres
not the elegant version of doin it.
Cheers Thomas
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 01:52
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from
Hi Jignesh,
But than I have the problem that I have 2 installations of postgres with
default settings on one machine. Is it possible to have two installations with
default settings on one machine?
Do they not interrupt each other with ports or something else?
Cheers Thomas
process which is provided from Solaris to remove it?
Whats the best way to do it?
Thank you for your help.
Cheers Thomas
Hi Jignesh,
Thanks for this information.
Did SUN make any other tests with SUN Machines and Postgres Databases?
Cheers Thomas
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jignesh K. Shah
Sent: Freitag, 4. April 2008 15:14
To: Thomas Bräutigam
Cc
Hi Robert
What do you think about the SUN T5120 or T5220 with a Postgres Database?
Cheers Thomas
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 3. April 2008 19:28
To: Thomas Bräutigam
Cc: pgsql-admin@postgresql.org; Jignesh K. Shah
Subject: Re
in 10-20 Seconds. Price for the Machine
doesn’t matter at all. The machine should just fit and can handle this kinda
huge database.
Cheers Thomas
-Original Message-
From: Michael Monnerie [mailto:[EMAIL PROTECTED]
Sent: Dienstag, 1. April 2008 14:54
To: Thomas Bräutigam
Cc: pgsql-admin
Hey,
I am very new in this mailing list and also very new in working with Postgres.
My questions is, is there a recommendation from Postgres about which SUN
Machine you should choose when you have a huge Postgres Database.
Cheers thomas
beware of timezone dst offset. try
select current_timestamp AT TIME ZONE 'MEST'
thomas
Julius Tuskenis schrieb:
Hello,
I have problem with postgreSQL current_timestramp. Where does it get
its value, because it doesnt match system time. The problem appeared
after this saturday-su
that the content became unavailable. After restoration from backup,
we haven't seen the errors again.
We're running 8.0.13 on FC3. Is there any reason not to suspect the
hardware at this point?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, fo
cription:
-john is my unix user
-postgresql server is reloaded
-connecting with my postgres user and md5 works fine
-connecting with "john" and METHOD ident sameuser works although fine
-why can't i connect with my unix user using md5 in pg_hba.conf ?
--
Hi,
How can I speed up updates?
i try an
update tablename set datecol=null
~ 2.3 mio rows
After 6 hours, this was still not finished. selects and inserts are ok.
System is a dual xeon, 8gb ram, debian 64bit, pg 8.1.4
thanks
thomas
--
Thomas Markus
Tel:+49 30 29 36 399 - 22
Fax
with PG 8.2 ...
Thomas
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil
Cache, cache, cache, cache.
Thomas Sattler
Morgan Stanley | Technology
750 Seventh Avenue, 14th Floor | New York, NY 10019
Phone: +1 212 762-1212
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Carol Walter
> Sen
1 - 100 of 334 matches
Mail list logo
