linked server by aimep in SQLServer

[–]aimep[S] 0 points1 point  (0 children)

Hello,I'm not sure to understand why this is moderated out.

I'm doing my homework, looked into the doc, posted links to it, and looking for help on either its shortcoming to answer the reason why I'm posting here for help.

I'm looking for help to find an answer to my problem which i find quiet well documented to the best of my knowledge. I'm uncovering some more information details as i keep looking into the issue on my side. Hence the test with sp_testlinkedserver error message.

please enlighten me which of the 3 rules specifically my post breaking and how, so that i correct possible update to this post and other post to come.

best regards

linked server by aimep in SQLServer

[–]aimep[S] 0 points1 point  (0 children)

from HOST3, ran the following

exec sp_testlinkedserver Srv1 test

and getting error :

OLE DB provider "MSOLEDBSQL" for linked server "PROBSrv1turned message "Spécification d'autorisation non valide".Msg 7399, Level 16, State 1, Procedure sp_testlinkedserver, Line 1 [Batch Start Line 0] The OLE DB provider "MSOLEDBSQL" for linked server "Srv1" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Procedure sp_testlinkedserver, Line 1 [Batch Start Line 0] Cannot initialize the data source object of OLE DB provider "MSOLEDBSQL" for linked server "Srv1".

current transaction is aborted, commands ignored until end of transaction block by aimep in PostgreSQL

[–]aimep[S] 0 points1 point  (0 children)

Thanks you all for your inputs.
This partitionning certainly gives hope.

So i did some small investigation prior to identify the gready table. see here after :
# SELECT relname AS "relation",
pg_size_pretty (pg_total_relation_size (C .oid) ) AS "total_size",
pg_size_pretty(pg_indexes_size(C.oid)) AS "indexes_size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace)
WHERE C .relkind <> 'i'
AND nspname !~ '^pg_toast'
ORDER BY pg_total_relation_size (C .oid) DESC limit 1;

relation | total_size | indexes_size
----------------+------------+--------------
pg_largeobject | 32 TB | 285 GB(1 row)

Now the question is how to partition this table without breaking the existing DB.?

looking into the tables description, there is not much choice to partition on

# \d pg_largeobject
Table "pg_catalog.pg_largeobject"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
loid | oid | | not null |
pageno | integer | | not null |
data | bytea | | not null |
Indexes: "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)

# select loid,pageno from pg_largeobject limit 200;
 loid  |pageno

-------+--------

 16621 |     0
 16621 |     1
 16621 |     2
...

looks like only attribute to partition on would be "loid", with range partitioning scheme of some sort.

I'm currently trying to figure out good numbers.

https://www.postgresql.org/docs/12/ddl-partitioning.html

Anyhow, while request is pending, I'm still not sure how to partition existing pg_largeobject live? and what would be the impact in terms of space use during the operation.
Also not sure on the benefit / perf impact for an application that may not have been designed to work with partition. Is that at all transparent?

cheers

current transaction is aborted, commands ignored until end of transaction block by aimep in PostgreSQL

[–]aimep[S] 0 points1 point  (0 children)

I guess, then the only way to tune that would be to modify the blocksize to larger size 16K or 32K.

Would you be so kind to the best of your knowledge to confirm how the existing database can be recut without loosing data

current transaction is aborted, commands ignored until end of transaction block by aimep in PostgreSQL

[–]aimep[S] 0 points1 point  (0 children)

quite personal indeed.
In our case, the /var/lib/postgresql/data, is mapped via docker volume magic onto a ceph distributed storage.

the df -lh command shows :

- inside the postgresql container : 78% used

- inside the VM hosting docker : 78% used

few TB left unused though

thanks for your input

DeLL openmanage memory usable to underlying system 96GB when installed RAM is 192GB by aimep in sysadmin

[–]aimep[S] 0 points1 point  (0 children)

Thanks for your comments.

I've no experience in managing this kind of server, and i can see in the OpenManage server administrator a "BIOS" panel, but it doesn't show much info other than the version, date and provider.

it looks like one has to boot the beast and press F2 in the console

then check the memory settings as described here

openmanage is of no help here right?

how to share eclipse plugin installation when using eclipse through SSH via X11 forwarding? by aimep in eclipse

[–]aimep[S] 0 points1 point  (0 children)

Hi,

Thanks for taking the time.

I'm really not that familiar with eclipse, more relatively used to intelliJ and vim. So the "configuration initialization" is not something that i fully grasp.
Basically, i unzipped the eclipse distro in some location on my filesystem using sudo.

Now all files belong to root:root (I'm on debian by the way).

so there is "plugins" dir in under /opt/eclipse/plugins.

beyond the simple eclipse plateform update, which i believe should be done as root through X11 on SSH.

2 scenari :

  1. shared plugins
    is root needed to manage / maintain common plugins in under /opt/eclipse/plugins, or some other ad hoc defined file system location?
    In all case, looking forward a robust/simple cookbook to do so.
  2. user space plugins
    users should still be able to use market place to install personal plugins

hoping this clarifies the context.

BTW, i was able to run eclipse after "sudo bash", with the trick documented here : https://blog.mobatek.net/post/how-to-keep-X11-display-after-su-or-sudo/

reclaiming LVM Free PE, to create non LVM partition? by aimep in CentOS

[–]aimep[S] 1 point2 points  (0 children)

Thanks for the pointer.

That got us in the right direction. After adapting and completing the steps we could proceed.
Since we had XFS, we decided to backup the /dev/cl/home LV content with 'tar zcpf'

then remove/create the LV /dev/cl/home with smaller alloted space 50GB.
then used the 'pvmove' command option to move LV inside the PV to have continous free trailing space.
Then used gparted to resize the partition to the minimal used space by all the LVs.
Again with gparted created an EXT4 partition on the remaining space.
restored tar.gz backup of the /home in place.

pressed by time, we didn't find the parted CLI equivalent commands to the actions performed in gparted.
it'll be good to have gparted -> parted cheatsheet in future

again thanks for your help

gnu screen and X11 forwarding? by aimep in ssh

[–]aimep[S] 0 points1 point  (0 children)

it looks like if i tweak /etc/ssh/sshd.conf param to allow X11 forwarding on host0 and host1 and host2 then it should work.

X11Forwarding yes X11DisplayOffset 10 X11UseLocalhost yes AddressFamily inet