Hi all,
When i am trying to install postgres 8.1.4 on my window
system i am facing problemsI am getting the following errors.Please suggest
me how can i overcome this and install successfully.
->Internal account lookup failure:Mo mapping between
account names and security IDs was don
I would take a quick guess at the
following:
-
If the
PC is on a domain, your logged on user account doesn’t have permissions
to lookup in AD
-
You’re
logged on account doesn’t have administrative rights on the PC
-
The user
you’re specifying as the PostgreS
To start off with, I would say it's that "ALTER TABLE" statement first.
I believe, as Michael said, it should be
ALTER COLUMN lugar.sitio TYPE varchar2(500)
Or ALTER COLUMN lugar.sitio TYPE varchar(500)
Andy
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-admin-
> [EMAIL PR
Hi :)
I have funny problem, which i don't understand. I'm adding new users to
PostgreSQL with some password (for example : "aa") and i can't log
in any database. But after that i change password to "bb" and i can
log in. Some passwords are good, and some are bad. And it depends on
user to
I need to test and create a procedure to restore
databases.
I followed the steps based on the site, but I couldn't
finish succesfully.
I did:
1. Put the database on Backup Mode and copy
datafiles.
/pg/bin/psql cresoldev -c "SELECT
pg_start_backup('/pg/backup/');"
tar -cvf /pg/backup/bk_b
Hello,
My hardware
CPU: Intel 3 GHZ X 4
Memory: 9 GB
LINUX
My conf file are as follows:
shared_buffers=1
wal_buffers=128
vacuum_mem = 256000
sort_mem=32768
max_fsm_pages = 300
max_fsm_relations = 32768
checkpoint_segments = 2048
checkpoint_timeout = 1800
checkpoint_warning = 300
effect
It looks like I
could cut down on max_fsm_relations (but I don't know if this should includes
system tables
or
not).
Don't know how to
interpret max_fsm_pages (see INFO message below); either:
- I am
within 16 pages of running out (19984 vs 2), or
- I need 19984 pages more
How sh
I have implemented GUID's in an application that needed them. We needed globally unique PK's and although Postgres did not offer them as a datatype, we used C# to perform that function. The Postgres database attribute ended up being a varchar(39). Not as performant as having Postgres natively do
I would have to agree with Benjamin here. With the money you save by running Postgres, you can buy another server. :)
Regards,
Paul
On 6/26/06, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote:
In addition to what Rodrigo said so eloquently in Portuguese (no fallu prtugues! ), the only
